set @errorSum =0 --初始化为0,即无错误
begin transaction
begin
set @errorSum=@errorSum+@@ERROR
if(@errorSum>0)
rollback transaction
else
commit transaction --提交回滚事务
end
BEGIN TRANSACTION
BEGIN TRY
IF EXISTS(SELECT 1 FROM #temp GROUP BY productID HAVING COUNT(1)>1)
BEGIN
SET @str=@str+‘对应的产品信息存在多行,请检查’
SELECT @str
ROLLBACK
RETURN
END
COMMIT TRAN
SELECT ‘’
END TRY
BEGIN CATCH
ROLLBACK TRAN
SELECT ERROR_MESSAGE()
END CATCH