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 vote371 views1 answer
Mysql check if lowercase
SQL
0 vote367 views2 answers
Postgresql variable in query
SQL
0 vote342 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
16 votes363 views3 answers
Tsql rename column name
SQL
0 vote352 views1 answer
Drop a field in psql django
SQL
0 vote315 views8 answers
Convert sql query to linq online
SQL
2 votes384 views5 answers
Install postgresql 10 centos 7
SQL
9 votes341 views2 answers
Mysql change value
SQL
0 vote344 views2 answers
Update all linkedserver tables with openquery on db
SQL
1 vote386 views2 answers
Extract weekday from date in sql
SQL