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 vote102 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote103 views1 answer
Sqlite3 get data from table c
SQL
7 votes104 views3 answers
Restore postgres database from sql file
SQL
9 votes97 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote94 views1 answer
Postgres set default schema
SQL
1 vote97 views1 answer
Drush sql-dump
SQL
1 vote93 views1 answer
Sql only five first row
SQL
0 vote109 views1 answer
Download sql file of countries names
SQL
1 vote151 views1 answer
How to select department from table
SQL
0 vote102 views1 answer
Mariadb cast null to 0
SQL