This blog shows on how to execute transactions in SQL Server using a SQL statement.
1
BEGIN TRANSACTION;
2
CREATE TABLE Table1(carcolumnint INT, carcolumn VARCHAR(10));
3
CREATE TABLE Table1(colName1 INT, colName2 VARCHAR(10));
4
COMMIT TRANSACTION;