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 vote154 views1 answer
Datatables server side filter where clause
SQL
0 vote118 views1 answer
Hangfire clean script
SQL
4 votes154 views2 answers
Postgresql default value
SQL
3 votes141 views1 answer
DB: in eloquent using sql
SQL
0 vote158 views1 answer
Select insert new table sql server
SQL
0 vote104 views1 answer
Delete all rows from table sqlite
SQL
0 vote158 views1 answer
Reset keys in sql
SQL
0 vote144 views1 answer
Sql server list user permissions
SQL
0 vote150 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
7 votes244 views2 answers
Mysql default value
SQL