DROP PROCEDURE exp3
GO
CREATE PROCEDURE exp3
@sn char(10)='2015200011',@sjh char(11)='12018060001',@kgcj int,@zgcj int,@cj int
AS
UPDATE cyjg
SET kgtcj=@kgcj,zgtcj=@zgcj,zcj=@cj
WHERE sno=@sn
AND s**h=@sjh;
EXECUTE exp3 67,26,93
为什么执行后更新不了数据