filmov
tv
How to recover deleted data from SQL | ROLLBACK command

Показать описание
How to recover deleted data from SQL,
How to rollback a deleted statement in sql.
DELETE AND ROLLBAcK COMMAND
SELECT * FROM tbEmployeeTable
case 1)
BEGIN TRAN
DELETE FROM tbEmployeeTable
ROLLBACK
CASE 2)
DELETE FROM tbEmployeeTable WHERE Emp_id=9;
ROLLBACK
CASE 3)
BEGIN TRAN
DELETE FROM tbEmployeeTable WHERE Emp_id=2;
ROLLBACK
How to rollback a deleted statement in sql.
DELETE AND ROLLBAcK COMMAND
SELECT * FROM tbEmployeeTable
case 1)
BEGIN TRAN
DELETE FROM tbEmployeeTable
ROLLBACK
CASE 2)
DELETE FROM tbEmployeeTable WHERE Emp_id=9;
ROLLBACK
CASE 3)
BEGIN TRAN
DELETE FROM tbEmployeeTable WHERE Emp_id=2;
ROLLBACK