摘要:
USE AdventureWorks;GOIF EXISTS (SELECT name FROM sys.objectsWHERE name = N'SaveTranExample')DROP PROCEDURE SaveTranExample;GOCREATE PROCEDURE SaveTranExample@InputCandidateID INTAS-- Detect if the procedure was called-- from an active transaction and save-- that for later use.-- In the proce 阅读全文