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 vote265 views1 answer
How to tell if i have lactose intolerance
SQL
4 votes246 views1 answer
Oracle show error line number
SQL
0 vote462 views1 answer
Get first match in each group mysql query
SQL
0 vote280 views1 answer
Pl/pgsql declare variable
SQL
0 vote298 views1 answer
Select year from dual oracle
SQL
1 vote276 views1 answer
How to use db.execute
SQL
1 vote283 views1 answer
Oracle sequence last_number
SQL
7 votes265 views2 answers
Execute mysql file
SQL
0 vote255 views1 answer
Sql get table last modified time
SQL
0 vote259 views2 answers
Timing sql queries
SQL