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 vote281 views1 answer
Pip install mysqlclient error
SQL
1 vote300 views1 answer
Mysql show queries running
SQL
18 votes247 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote289 views2 answers
Nested query
SQL
-1 vote304 views4 answers
Postgres between dates
SQL
0 vote281 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote347 views2 answers
How to check if a column exists in a SQL Server table?
SQL
2 votes295 views5 answers
SQL trigger
SQL
0 vote286 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
14 votes306 views1 answer
Oracle alter table add column not null
SQL