sql写成字符串执行

DECLARE @m nvarchar(max) SET @m = N'DECLARE @t TABLE (ID int);INSERT INTO @t VALUES (1);SELECT * FROM @t T' EXEC sp_executesql @m

转载于:https://www.cnblogs.com/lfzwenzhu/archive/2009/02/24/1397141.html