Wednesday, August 18, 2010

SQL Server 2008: Insert results from stored procedure into table

All thanks to SQL Server 2008 TABLE datatype, results from a stored procedure can now be stored in a variable of TABLE datatype WITHOUT having to do any sp_configure.

declare @tempTable table (
    ID int not null,
    Points int not null
)
insert into @tempTable
exec cspSample @ID = 1
 
select * from @tempTable

No comments:

Post a Comment

Do provide your constructive comment. I appreciate that.