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 vote211 views1 answer
Initcap in mysql
SQL
0 vote270 views1 answer
Order by number of character in sql
SQL
0 vote213 views1 answer
Shell script to log mysql cpu usage
SQL
6 votes223 views3 answers
Date_trunc postgres
SQL
9 votes211 views2 answers
Sql limit order by
SQL
11 votes189 views4 answers
MYSQL LOGIN
SQL
0 vote292 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
1 vote202 views1 answer
Sql where last 12 months
SQL
16 votes226 views2 answers
Sql vs nosql
SQL
3 votes256 views1 answer
Sql several or
SQL