静态
SELECT [Dep_CnName]
FROM [master].[dbo].[Depart]
修改为动态
declare @test nvarchar(128)
set @test='Dep_CnName' /*列名*/
exec ('select '+ @test+' from Depart')
增加参数
DECLARE @IntVariable INT,@SQLString NVARCHAR(500),@ParmDefinition NVARCHAR(500);
SET @SQLString =N'SELECT * FROM Depart WHERE Dep_Id = @Field'; --给需要执行的sql赋值
SET @ParmDefinition = N'@Field int'; --以字符串的形式给第二个参数赋值
SET @IntVariable = 13; --给需要传入的参数赋值
EXECUTE sp_executesql @SQLString, @ParmDefinition,@Field = @IntVariable;