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 votes361 views1 answer
Mysql check date range
SQL
0 vote380 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote358 views1 answer
Formatting code with SQL Developer
SQL
0 vote312 views1 answer
Select mysql limit to 2 decimal places
SQL
2 votes388 views2 answers
Sql lag
SQL
2 votes360 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote380 views1 answer
Selecting duplicates
SQL
0 vote358 views4 answers
Forenkey code alchemy sql
SQL
1 vote347 views1 answer
Oracle create index if not exists
SQL
0 vote450 views1 answer
What is common table expression in sql
SQL