Question

sql存储过程怎么使用变量来替代列名，比如select * from Table where @c

sql存储过程怎么使用变量来替代列名，比如select * from Table where @col =@KeyWord

Answer 1

那就SQL语句需要变为动态的

declare @str varchar(100)
set @str = 'select * from Table where ' + @col + '=' + @KeyWord
exec(@str)

追问

执行过程的时候会报错 比如说我的@col输入为“学生”，@KeyWord输入为“张三”，它会弹出说列名“张三”无效，这是为什么

追答

如果你那字段是字符串，那么就要改为：

declare @str varchar(100)
set @str = 'select * from Table where ' + @col + '=''' + @KeyWord + ''''
exec(@str)

Answer 2

CREATE PROCEDURE HumanResources.uspGetEmployeesTest2
@LastName nvarchar(50),
@FirstName nvarchar(50)
AS
SET NOCOUNT ON;
SELECT FirstName, LastName, Department
FROM HumanResources.vEmployeeDepartmentHistory
WHERE FirstName = @FirstName AND LastName = @LastName
AND EndDate IS NULL;
GO

追问

是回答我提的问题的吗？