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

8 votes199 views3 answers
Postgres database sizes
SQL
1 vote199 views1 answer
Insert pg result of select
SQL
1 vote145 views1 answer
Postgres check for foreign key
SQL
0 vote175 views1 answer
Sql waitfor
SQL
7 votes165 views6 answers
Group_concat in mysql
SQL
8 votes138 views1 answer
Oracle add month
SQL
0 vote222 views1 answer
Sql database size
SQL
2 votes165 views1 answer
Sqlite3 show columns name
SQL
0 vote168 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote162 views1 answer
Sql query to get column names and data types in sql server
SQL