SQL ¶¯Ì¬±íÃûµÄÎÊÌâ

SQL code:

@tb varchar(255)

select * from @tb



²»ÄÜÓÃexec·½·¨À´ÊµÏÖ,execÎÒ×Ô¼º»á¡£ÇëÎÊÓÃSQLÓï¾äfromºóÃæÓ¦¸ÃÔõôÑùʵÏÖ£¿

---

±íÃû¶¯Ì¬ ²»ÓÃexec¾ÍÓÃexec sp_executesql

---

ÒýÓÃ

SQL code

@tb varchar(255)

select * from @tb

²»ÄÜÓÃexec·½·¨À´ÊµÏÖ,execÎÒ×Ô¼º»á¡£ÇëÎÊÓÃSQLÓï¾äfromºóÃæÓ¦¸ÃÔõôÑùʵÏÖ£¿

µ±±íÃû»òÁÐÃûÊDZäÁ¿Ê±£¬ÐëÓö¯Ì¬SQL

---

Â¥ÉϵÄÀÏ´ó¡£²»ÄÜÖ±½ÓÓÃÓï¾äʵÏÖÂð£¬Ò»¶¨Òª¼Óexec sp_executesql?

---

ÒýÓÃ

Â¥ÉϵÄÀÏ´ó¡£²»ÄÜÖ±½ÓÓÃÓï¾äʵÏÖÂð£¬Ò»¶¨Òª¼Óexec sp_executesql?

²»ÄÜ

---

SQL code:
declare @tb varchar(255)
set @tb='sysobjects'
exec('select * from '+@tb)




name id xtype uid info status base_schema_ver replinfo parent_obj crdate ftcatid schema_ver stats_schema_ver type userstat sysstat indexdel refdate version deltrig instrig updtrig seltrig category cache
-----------------------------------