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

1 vote352 views1 answer
Error code 1055
SQL
0 vote337 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote318 views1 answer
Expose db in virtualbox
SQL
0 vote364 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
5 votes373 views2 answers
Create function postgresql
SQL
13 votes388 views3 answers
Change data type postgresql
SQL
1 vote364 views1 answer
How to drop function in sql
SQL
0 vote383 views1 answer
Load data infile mariadb slow
SQL
0 vote367 views1 answer
Sql add calculated column
SQL
1 vote377 views2 answers
Find nth highest salary of an employee
SQL