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 vote195 views1 answer
Oracle running queries
SQL
0 vote180 views1 answer
Insert value in identity
SQL
19 votes164 views3 answers
Grant mysql
SQL
0 vote172 views3 answers
Mysql regex replace
SQL
13 votes161 views4 answers
What is sql
SQL
2 votes155 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote175 views1 answer
Including parameters in OPENQUERY
SQL
0 vote156 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
1 vote107 views1 answer
Postgresql last element of array
SQL
0 vote156 views1 answer
Oracle service name view
SQL