SQL Transaction command Use
· Transaction Command This Command is use to Perform Two more command Execute in one Time . If Any insert queary is fail than Other queary is Rollback . Example : CREATE PROCEDURE [dbo].[insertDatePROCE] AS BEGIN TRY BEGIN TRAN INSERT INTO test ( studentname, std, IsActive, CreationDate, studentAddress ) values ( 'BHAVYA', 6, 1, GETDATE(), 'RAJKOT' ); INSERT INTO test ( studentname, std, IsActive, CreationDate, studentAddress ) values ( 'JAYRAJ', 8, 1, GETDATE(), 'RAJKOT' ); INSERT INTO test ( studentname, std, IsActive, CreationDate, studentAddress ) values ( 'URVEE', 7, 1, GETDATE(), 'AHEMDABAD' ); COMMIT TRAN END TRY BEGIN CAT...