2,496
社区成员
发帖
与我相关
我的任务
分享
create proc proc_sql
@num int,
@c int--传入的值
as
SELECT @num = FROM SYGCRLK WHERE seqno = 1 AND craftcode = '017';
@num = @num + @c;
UPDATE SYGCRLK SET seqno = @num WHERE seqno = 1 AND craftcode = '017';
go