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

9 votes244 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote249 views1 answer
Mariadb cast to int
SQL
0 vote257 views1 answer
Sql quary stuf
SQL
0 vote235 views1 answer
Sql server check whether column has same equal values
SQL
13 votes213 views2 answers
Display users in mysql
SQL
0 vote234 views1 answer
SQL FROM-Klausel
SQL
8 votes237 views2 answers
Safe update mode in mysql
SQL
8 votes218 views2 answers
Mysql query dates between two dates
SQL
0 vote252 views1 answer
Mysql disable triggers
SQL
3 votes257 views2 answers
Check data in table mysql
SQL