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 vote309 views2 answers
Postgres show current role
SQL
0 vote329 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote322 views1 answer
Hour differeence in mysql
SQL
0 vote279 views1 answer
Oracle sql date summer time
SQL
0 vote293 views1 answer
How to print out column name differently in mysql
SQL
0 vote284 views1 answer
Insert or update cassandra
SQL
0 vote303 views1 answer
Db format in quotation
SQL
0 vote302 views1 answer
Sqlplus change user
SQL
0 vote307 views1 answer
Como hacer una consulta en sql
SQL
0 vote288 views2 answers
Sqlite
SQL