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

1 vote114 views1 answer
Hackerrank sql test solutions
SQL
0 vote121 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
1 vote120 views1 answer
Postgres convert date to string
SQL
0 vote116 views1 answer
Lesser than or equal to symbol in postgres
SQL
5 votes124 views2 answers
Ranking functions in sql
SQL
9 votes137 views3 answers
Postgres make sql dump
SQL
0 vote120 views1 answer
How to convert external table to managed table in hive
SQL
1 vote112 views1 answer
Order by oracle
SQL
11 votes123 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote107 views1 answer
Selecting Data in SQL - Select Data
SQL