字符串中的变量
declare @A nvarchar(50)declare @B table(id int)insert into @B ([id]) values(1)set @A = 'select * from @B'exec sp_executesql @A
declare @A nvarchar(500)set @A = 'declare @B table(id int);insert into @B values(1);select * from @B;'exec sp_executesql @A-- 结果id-----------1