Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Exec return value

Author  Topic 

shahidhameedwah
Starting Member

5 Posts

Posted - 2008-07-31 : 07:18:20
Hi all

I have a query "select @t = table from tableslist", and i need to exec it using Exec method. Who can i get return value in @t

Regards

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-31 : 08:07:18
use sp_executesql instead


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-31 : 09:40:42
http://msdn.microsoft.com/en-us/library/ms188001.aspx
Go to Top of Page
   

- Advertisement -