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

0 vote305 views1 answer
Sql developer format sql
SQL
1 vote317 views1 answer
Mysql monthname
SQL
0 vote319 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote320 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote362 views1 answer
Postgres list tables and row counts
SQL
0 vote329 views1 answer
Mysql undo delete
SQL
0 vote337 views1 answer
Mysql query to select the highest value
SQL
0 vote336 views2 answers
How to install mssql on mac
SQL
3 votes309 views1 answer
How to remove characters from string in mysql
SQL
1 vote319 views1 answer
Postgres install unaccent extension
SQL