我想知道是否可以抑制SQL存储过程中的事务。我的SP中有以下情况（我希望实现）：
WHILE TRUE
BEGIN TRY
BEGIN TRANSACTION A
RECEIVE MESSAGE FROM SSB QUEUE WITH TIMEOUT
BEGIN SUPPRESS TRANSACTION
WHILE RECORD IN TABLE
BEGIN TRANSACTION B
DELETE RECORD FROM TABLE OUTPUT RECORD INTO D
SEND RECORD D TO OTHER SSB QUEUE
COMMIT TRANSACTION B
END SUPPRESS TRANSACTION
COMMIT TRANSACTION A
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION A
END CATCH
所以我真正想做的是事务B没有被列入事务A :)