CREATE PROCEDURE writestudentscore
(
@score nvarchar
@userID int
@coursenumber nvarchar
)
AS
declare @strSql varchar(8000)
select @strSql='update users set course'+@coursenumber+'='+''''+@score+''''+' where userID='+''''+@userID+''''
exec(@strSql)
(
@score nvarchar
@userID int
@coursenumber nvarchar
)
AS
declare @strSql varchar(8000)
select @strSql='update users set course'+@coursenumber+'='+''''+@score+''''+' where userID='+''''+@userID+''''
exec(@strSql)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货