SQL2008关于quotename的用法

declare @tbname varchar(256),@sql varchar(256)
set @tbname='index'

---查这个表里的数据:
print(@tbname)
set @sql = 'select * from '+QUOTENAME(@tbname)
print(@sql)
exec(@sql)

 

posted @ 2016-10-29 00:03  婧児  Views(169)  Comments(0Edit  收藏  举报