sql»ù±¾³£Ê¶ÎÊÌâ

declare @aa varchar(50)
set @aa='select * from table'
¿ÉÒÔÖ´ÐÐÕâ¸ö@aaÂ𠣿Èç¹û¿ÉÒÔÔõôִÐУ¿ лл

---

SQL code:
declare @aa varchar(50)
set @aa='select * from table'
exec(@aa)

---

SQL code:
declare @aa varchar(50)
set @aa='select * from table'
EXEC(@AA)

---

SQL code:

declare @aa varchar(50)
set @aa='select * from table'
exec(@aa)--ʹÓö¯Ì¬SQL

---

SQL code:
¶¯Ì¬SQLÓï¾ä

1:ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃExecÖ´ÐÐ
eg: Select * from tableName
Exec('select * from tableName')
exec sp_executesql N'select * from tableName' -- Çë×¢Òâ×Ö·û´®Ç°Ò»¶¨Òª¼ÓN


2:×Ö¶ÎÃû£¬±íÃû£¬Êý¾Ý¿âÃûÖ®Àà×÷Ϊ±äÁ¿Ê±£¬±ØÐëÓö¯Ì¬SQL
eg:
declare @fname varchar(20)
set @fname = '[name]'
Select @fname from sysobjects -- ´íÎó
Exec('select ' + @fname + ' from sysobjects') -- Çë×¢Òâ ¼ÓºÅÇ°ºóµÄ µ¥ÒýºÅµÄ±ßÉÏÒª¼Ó¿Õ¸ñ
exec sp_executesql N' select ' + @fname + ' from sysobjects'
µ±È»½«×Ö·û´®¸Ä³É±äÁ¿µÄÐÎʽҲ¿É
declare @s varchar(1000)
set @s = 'select