How to recover deleted data from SQL | ROLLBACK command

preview_player
Показать описание
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
Рекомендации по теме
welcome to shbcf.ru