declare @errorStr integer
..........
UPDATE authors SET au_id = '172 32 1176'
WHERE au_id = "172-32-1176"
SEt @errorStr=@@ErrorReturn(@errorStr)
..........
UPDATE authors SET au_id = '172 32 1176'
WHERE au_id = "172-32-1176"
SEt @errorStr=@@ErrorReturn(@errorStr)
但我这所有的逻辑只能用存储过程
begin
....
end
@@error<>0就是有错误发生
我只知道这么多,呵呵