declare @tempTable table (
ID int not null,
Points int not null
)
insert into @tempTable
exec cspSample @ID = 1
select * from @tempTable
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.
Subscribe to:
Post Comments (Atom)
Popular Posts
-
According to a report in TodayOnline , Temasek-linked firms may post lower dividends this year. Even billionaire Warren Buffett's Berksh...
-
Singapore’s Land Transport Authority has just released an updated official MRT map including one additional station on the North East Line (... -
*********** Try to sleep now, close your eyes Soon the birds would stop singing Twinkling stars, are shining bright They'll be watch...
-
Robocopy, short for "Robust File Copy" is an advanced command-line utility included in Windows. It's designed to copy files an...
-
I would like to apologize that sigining of my guestbook is not possible at the moment due to an unexpected bug. There is already 74 entries ...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.