Begin transaction in sql

BEGIN TRANSACTION [Tran1]

  BEGIN TRY

      INSERT INTO [Test].[dbo].[T1] ([Title], [AVG])
      VALUES ('Tidd130', 130), ('Tidd230', 230)

      UPDATE [Test].[dbo].[T1]
      SET [Title] = N'az2' ,[AVG] = 1
      WHERE [dbo].[T1].[Title] = N'az'

      COMMIT TRANSACTION [Tran1]

  END TRY

  BEGIN CATCH

      ROLLBACK TRANSACTION [Tran1]

  END CATCH

Source: stackoverflow.com

Begin transaction sql

-- It is Transaction Control Language(TCL)
-- case1 (temporary)
BEGIN TRANSACTION
-- perform DML operation i.e. INSERT, UPDATE, DELETE
ROLLBACK -- goes to previous state 

-- case2 (permanent)
BEGIN TRANSACTION
-- perform DML operation i.e. INSERT, UPDATE, DELETE
COMMIT -- Transaction is executed and hence change is done permanently

Similar codes

0 vote216 views1 answer
Declaring variables in pl sql
SQL
0 vote255 views1 answer
Time data type in mysql
SQL
0 vote239 views1 answer
Can you write relational algebra into sql queries
SQL
1 vote199 views1 answer
Foreign key in oracle sql developer
SQL
53 votes444 views6 answers
How to install mysql ubuntu
SQL
0 vote243 views1 answer
Sql delete caracter list
SQL
0 vote248 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote248 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote236 views1 answer
Online sql testing tool
SQL
0 vote289 views1 answer
Mssql find deadlocks
SQL