create proc stupdate
@sex varchar(5),
@score int
as
update dbo.StuMarks set @score=Score+@score where @sex='男'
goexec dbo.stupdate '男',5各位大哥大姐们,为什么我执行后表没有更新啊?
谢谢!
@sex varchar(5),
@score int
as
update dbo.StuMarks set @score=Score+@score where @sex='男'
goexec dbo.stupdate '男',5各位大哥大姐们,为什么我执行后表没有更新啊?
谢谢!
create proc stupdate
@sex varchar(5),
@score int
as
update dbo.StuMarks set score=Score+@score where sex=@sex
goexec dbo.stupdate '男',5