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 vote145 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
13 votes150 views4 answers
Command line mysql import
SQL
7 votes131 views1 answer
Sql disable safe mode
SQL
0 vote133 views1 answer
Sql select column names starting with
SQL
3 votes133 views3 answers
Remove all spaces from string sql
SQL
0 vote146 views1 answer
Mssql + bit + in python orm
SQL
0 vote124 views1 answer
Mysql money value
SQL
1 vote136 views1 answer
Mysql copy table1 to table2
SQL
2 votes125 views2 answers
Change varchar length mysql
SQL
2 votes131 views2 answers
Sql first character
SQL