写动态sql语句
declare @c char(22),@d char(11),@s varchar(8000)
set @b='aa'
set @c='productname'
set @s= 'select productid,productname as'+ @d+'where productname='+@c
exec @s
declare @c char(22),@d char(11),@s varchar(8000)
set @b='aa'
set @c='productname'
set @s= 'select productid,productname as'+ @d+'where productname='+@c
exec @s
set @b='aa'
set @c='productname'
set @s = 'select productid,productname as '+@d +' where productname='''+@c+''''
exec(@s)
set @b='aa'
set @c='productname'
exec('select productid,productname as ['+@d +']
where productname='''+@c+'''')