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 vote302 views1 answer
Sqlite3 not commit
SQL
0 vote319 views1 answer
Postgres 11 add primary key
SQL
0 vote334 views1 answer
Where field is null sql knex
SQL
3 votes344 views2 answers
MySQL query to get column names
SQL
3 votes458 views1 answer
How to get yesterday date in sql
SQL
0 vote328 views1 answer
Mysql coonect sample code
SQL
0 vote297 views1 answer
Sql select maximum column with other columns returned
SQL
4 votes310 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
7 votes407 views2 answers
Drop index oracle
SQL
7 votes356 views5 answers
Oracle alter table
SQL