Transact-SQL is an actively used query language created in 1984.

35Years Old 7,875Users 44Jobs

Example code from Wikipedia:

-- begin transaction
BEGIN TRAN

BEGIN TRY
   -- execute each statement
   INSERT INTO MYTABLE(NAME) VALUES ('ABC')
   INSERT INTO MYTABLE(NAME) VALUES ('123')

   -- commit the transaction
   COMMIT TRAN
END TRY
BEGIN CATCH
   -- roll back the transaction because of error
   ROLLBACK TRAN
END CATCH
Edit

Last updated February 11th, 2019