CREATE PROCEDURE [dbo].[usp_savePurchaseDetails]( @customerId varchar(50), @productId varchar(50), @userName varchar(50), @bomEmailId varchar(50), @amazonId varchar(50), @phoneNumber varchar(50), @status smallint, @firstName varchar(50), @middleName varchar(50), @lastName varchar(50), @homeName varchar(50), @street varchar(50), @city varchar(50), @state varchar(50), @country varchar(50), @zipCode varchar(50), @mobile varchar(50), @homePhone varchar(50) ) AS BEGIN BEGIN TRANSACTION INSERT INTO BomAmazonCustomers (customerId,productId,userName,bomEmailId,phoneNumber,amazonId,purchasedDate,status) VALUES (@customerId,@productId,@userName,@bomEmailId,@phoneNumber,@amazonId, GETDATE(),@status) IF @@ERROR = 0 BEGIN INSERT INTO bomAmazonCustomersAddress (bomEmailId,firstName,middleName,lastName,houseName,street,city,state,country,zipCode,mobile,homePhone) VALUES (@bomEmailId,@firstName,@middleName,@lastName,@homeName,@street,@city,@state,@country,@zipCode,@mobile,@homePhone) IF @@ERROR = 0 BEGIN COMMIT TRANSACTION END ELSE BEGIN ROLLBACK TRANSACTION RETURN END END ELSE BEGIN ROLLBACK TRANSACTION RETURN END END
Wednesday, October 31, 2012
Ms Sql Transation
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment