SQL. How to use select from Storage

Declare @T Table ([column definitions here])
Insert @T Exec storedProcname params Select * from @T

https://stackoverflow.com/questions/1492411/sql-server-select-from-stored-procedure

Passing complex parameters to a stored procedure (Key Dictionary)

Declaration and initialization

declare @d DictionaryParameter


insert into @d([Key],Value)
select 1,2
union all
select 3,4

And usage :

declare @s1 nvarchar(max)

EXEC [dbo].[falcon_sitemap]
    @parameters = @d,
    @s = @s1 OUTPUT
Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started

Falcon Space Platform

This is a reduction in the cost of ownership

at the expense of fewer people to support

This is a quick change

while using the program

This is a modern interface

full adaptation for mobile devices

 
Note