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 vote188 views1 answer
Repeatable read trong sql server
SQL
0 vote161 views1 answer
Create dabase postgresql
SQL
0 vote204 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote177 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote202 views1 answer
Mysql url
SQL
0 vote174 views1 answer
A network or instance-specific error sql server
SQL
12 votes180 views1 answer
Docker mysql random root password
SQL
1 vote208 views1 answer
Myql find duplicates
SQL
1 vote146 views2 answers
Show sql logs in spring boot
SQL
0 vote178 views1 answer
Sql grant select only
SQL