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 votes147 views2 answers
Mysql count rows returned
SQL
3 votes200 views1 answer
How to get yesterday date in sql
SQL
0 vote141 views1 answer
Convert sql server guid to varbinary
SQL
0 vote136 views1 answer
Oracle locked objects
SQL
1 vote160 views1 answer
Default
SQL
17 votes140 views6 answers
Sql select distinct
SQL
0 vote144 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote150 views1 answer
Get id if is not equal in certain table
SQL
0 vote165 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
2 votes161 views1 answer
Sql server current date minus 5 years
SQL