Testing sql queries

Sql testing queries

CREATE TABLE mytables(id INT identity(1,1) ,colName NVARCHAR(255));
INSERT INTO mytables(colName)
VALUES('***');
INSERT INTO mytables(colName)
VALUES('bla');

BEGIN TRANSACTION
DELETE FROM myTables
WHERE colName = '***';
SELECT * FROM myTables; -- Result #1
ROLLBACK TRANSACTION

SELECT * FROM myTables; -- Result #2

Source: dba.stackexchange.com

Similar codes

1 vote104 views1 answer
Declare table variable
SQL
0 vote98 views1 answer
Name '_mysql' is not defined
SQL
1 vote123 views1 answer
Sql view where tables have same column name combine results
SQL
17 votes109 views6 answers
Change column name in sql
SQL
13 votes117 views1 answer
Sql join 3 tables on id
SQL
0 vote96 views1 answer
Date diff sql
SQL
1 vote108 views1 answer
Sql server find tables referenced foreign key
SQL
5 votes101 views1 answer
Mysql get last day of month
SQL
0 vote123 views2 answers
Compound operator in sql
SQL
0 vote106 views1 answer
Execut sql python
SQL