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
-
新加坡人口400万,亚洲人口4亿,全世界人口6亿。 但是,我一人可能就很有可能是世界最傻的了。我真是个不折不扣的大木头。真是受不了自己。
-
For anyone living in or visiting Singapore, mastering the public transport system is a rite of passage. While the MRT is efficient, the exte...
-
*********** Try to sleep now, close your eyes Soon the birds would stop singing Twinkling stars, are shining bright They'll be watch...
-
I got the below findings from Taipei , Hong Kong and Singapore and I thought I should share them with all of you. Taxi Fares In Taipei Tax...
-
The Consumers Association of Singapore (CASE) response on the planned 21% electricity tariff hike says it all. CASE advise Singaporeans to ...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.