Hi, the below is the process of inserting records into SQL Table Using Distributed Transactions
BEGIN TRANSACTION
INSERTINTODACS_Telephones(Registration, Mobile)Values('Nag','Reg')
IF @@ERROR <> 0
BEGIN
ROLLBACK TRANSACTION
END
INSERTINTO Vehicle ([ID],Reg_Trim,Warehouse_ID)Values('Naga','Regist','w1')
IF @@ERROR <> 0
BEGIN
ROLLBACK TRANSACTION
END
COMMIT TRANSACTION
Monday, 24 November 2008
Subscribe to:
Posts (Atom)