sqlexec

Hi
How can i execute a piece of sqlstmt which is stored in a string variable
from query ****yser.
for ex:@var1="select name,code from" + @var2
--
Thanks

Hi,

This is actually a dynamic SQL and can be executed using one of the below :-

EXEC(@Var1)

or

exec sp_executesql @Var1

Thanks
Hari
SQL Server MVP

Hi shif,

http://www.sommarskog.se/dynamic_sql.html

--
Hugo Kornelis, SQL Server MVP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 27th August 10:52 External User External User Posts: 1	sqlexec Hi How can i execute a piece of sqlstmt which is stored in a string variable from query ****yser. for ex:@var1="select name,code from" + @var2 -- Thanks

2 27th August 19:35 hari prasad External User Posts: 1	sqlexec Hi, This is actually a dynamic SQL and can be executed using one of the below :- EXEC(@Var1) or exec sp_executesql @Var1 Thanks Hari SQL Server MVP

3 27th August 19:35 hugo kornelis External User Posts: 1	sqlexec Hi shif, http://www.sommarskog.se/dynamic_sql.html -- Hugo Kornelis, SQL Server MVP