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 vote302 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote396 views1 answer
How to check common records in 2 table
SQL
0 vote307 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
19 votes352 views5 answers
Display table in sql
SQL
2 votes302 views2 answers
Install sqlalchemy
SQL
1 vote306 views1 answer
User privileges postgresql information_schema
SQL
0 vote409 views1 answer
Reset a table's identity column and remove test records
SQL
1 vote305 views2 answers
String to date postgres
SQL
2 votes308 views2 answers
Compare date mysql
SQL
0 vote312 views1 answer
How to open mysql in docker
SQL