CREATE PROCEDURE dbo.UpdateStuRegBySetField
@studentid varchar(50),
@setvalue varchar(255)
AS
exec("update stu_register set "+@setvalue+" where studentid=@studentid")
GO
CREATE PROCEDURE dbo.UpdateStuRegBySetField @studentid varchar(50), @setvalue varchar(255) AS exec("update stu_register set "+@setvalue+" where studentid=@studentid") GO 其中的@studentid要加上'',否则就会说类型转换错误,怎么办呢?我改了很多次都不行,高手帮忙了。谢谢
CREATE PROCEDURE dbo.UpdateStuRegBySetField
@studentid varchar(50),
@setvalue varchar(255)
AS
exec("update stu_register set "+@setvalue+" where studentid=" + @studentid)
GO