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 vote190 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote149 views1 answer
Update row in sqlite python
SQL
0 vote189 views1 answer
Remove binlog mysql
SQL
6 votes218 views1 answer
How to get the size of the database in postgresql
SQL
1 vote212 views1 answer
Mysql connect bash
SQL
0 vote194 views1 answer
Mysql wsrep ls
SQL
0 vote191 views1 answer
Dnsmasq.conf location macos
SQL
0 vote185 views1 answer
In mysql workbench contnent not feching
SQL
0 vote191 views1 answer
Heidisql check how much space a row
SQL
1 vote210 views1 answer
Last 24 HOUR data in mysql
SQL