Use Temp Table Variable in Stored Procedure
I'm playing with simple stored procedure with declared table variable as below:
I use the following codes to do this:
Is there any issue I need to take care of? It seems to have something to do with the table variable?
Answering my own question and for others who might benefit:
This is what I need to do, I added "SET NOCOUNT ON" in the beginning of the stored procedure to send back a closed recordset.
I wrote a post about this a while ago - you essentially need to form the sql statement first by declaring a long varchar and then executing it.
|All times are GMT -4. The time now is 10:19 PM.|
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.