declare @tempTable table ( ID int not null, Points int not null ) insert into @tempTable exec cspSample @ID = 1 select * from @tempTable
Computer, Technology, Databases, Google, Internet, Mobile, Linux, Microsoft, Open Source, Security, Social Media, Web Development, Business, Finance
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
-
Google url shortener service, goo.gl , is now much improved with newly included features like easier copy and paste, and ability to delete e...
-
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 ...
-
The Google Adsense made a blog post with a video to help us understand the concept behind eCPM (Effective Cost Per Thousand Impressions). ...
-
As of today, Google will start using a new shortened url - g.co , to promote Google websites. g.co works differently as compared to a long-t...
-
I hope the following will come handy when it comes to generating key pairs and certificates. # Generate a Private Key openssl genrsa -out p...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.