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 vote260 views1 answer
How to insert multiple values in a single column in sql
SQL
1 vote379 views1 answer
Postgres upgrade to superuser
SQL
0 vote245 views1 answer
Select even number id data from table
SQL
0 vote236 views1 answer
Mysql select where field like in list
SQL
0 vote277 views1 answer
Postgres list all triggers
SQL
0 vote211 views1 answer
Mysql date + 1 day
SQL
0 vote790 views1 answer
Mysql custom sort order
SQL
5 votes221 views1 answer
Oracle list packages
SQL
0 vote231 views1 answer
Load utilities in sql server
SQL
0 vote238 views1 answer
Foreign key multiple columns
SQL