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

5 votes132 views4 answers
Describe table postgres
SQL
0 vote150 views1 answer
Sql query to get contact form 7 fields
SQL
8 votes142 views1 answer
Sql remove leading spaces
SQL
0 vote184 views1 answer
Sql developer format sql
SQL
1 vote92 views1 answer
Postgres reset auto increment
SQL
0 vote123 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote162 views1 answer
Sql remove decimal places
SQL
0 vote133 views1 answer
Inner joint
SQL
0 vote146 views1 answer
Get date from timestamp in mysql
SQL
10 votes136 views1 answer
Oracle view dependencies
SQL