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

2 votes325 views2 answers
Oracle create table if not exists
SQL
1 vote308 views3 answers
Date_add mysql
SQL
3 votes269 views1 answer
Index using in query plsql
SQL
11 votes301 views1 answer
Oracle view source
SQL
1 vote284 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote265 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote278 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote276 views1 answer
Ilike for date postgres
SQL
1 vote368 views1 answer
Sql and
SQL
0 vote308 views2 answers
Execute stored procedure without db set
SQL