存储过程
ALTER PROCEDURE [dbo].[FCase]@SEQ nvarchar(50),
@AssignDate datetime,
@Request nvarchar(1000),
@dEmpID nvarchar(50)
AS
begin
begin transaction
update jobmaster set AssignDate=@AssignDate,Flag='2assigned',Request='@Request',dEmpID='@dEmpID' where SEQ='@SEQ'
update DutyClerk set Status='B',state='B' where EmpID='@dEmpID'
if @@error<>0
rollback transaction
else
commit transaction
end
这个存储过程有问题吗？
