sql 触发器里,发生错误,回滚提示错误语句
SET @msg='错误消息';
RAISERROR(@msg, 16, 1);
ROLLBACK TRANSACTION;
close LimitAddOrder;
DEALLOCATE LimitAddOrder;
RETURN;
SET @msg='错误消息';
RAISERROR(@msg, 16, 1);
ROLLBACK TRANSACTION;
close LimitAddOrder;
DEALLOCATE LimitAddOrder;
RETURN;