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)
-
Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed m...
-
If you have been reading the mainstream media or the social media, it is likely that you would have heard of SimplyGo - an initiative by the...
-
Cecilia Cheung (张柏芝) is planning to sue famous artist and principal of an Arts and Sciences College in Nanjing, Yang Linchuan (杨林川), for hav...
-
New set of date ranges for the 12 13 zodiac signs Capricorn - Jan 20 to Feb 16 Aquarius - Feb 16 to Mar 11 Pisces - Mar 11 to Apr 18 Ar...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.