wilfordrocks
asked on
How to run the script stored in a variable?
DECLARE @XSQL AS VARCHAR(8000)
--assume the variable @XSQL was loaded from a select statement.
--How can I execute it?
SET @XSQL = 'select * from tblTable where Tableid=921'
EXECUTE or GO @XSQL
--assume the variable @XSQL was loaded from a select statement.
--How can I execute it?
SET @XSQL = 'select * from tblTable where Tableid=921'
EXECUTE or GO @XSQL
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
DECLARE @XSQL AS VARCHAR(8000)
SET @XSQL = 'select * from tblTable where Tableid=921'
EXEC(@XSQL)
SET @XSQL = 'select * from tblTable where Tableid=921'
EXEC(@XSQL)
EXECUTE (@XSQL)
You can also use the shortened form
EXEC (@XSQL)