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 vote131 views1 answer
Bidirectional outer join sql
SQL
0 vote122 views2 answers
How to set global time_zone in mysql
SQL
1 vote151 views1 answer
Mysql connect command
SQL
-1 vote142 views1 answer
Adding a new table psql
SQL
0 vote125 views1 answer
Mysql create table columns with spaces
SQL
28 votes172 views6 answers
Foreign key
SQL
6 votes130 views2 answers
Mysqldump password in file
SQL
1 vote120 views1 answer
Sql server 2012 query history
SQL
0 vote140 views2 answers
Return the number of records in a single table mysql
SQL
1 vote144 views1 answer
Delete specific row in sql
SQL