Answer Posted / elumalai.k

begin transaction
save transcation t
delete from tablename where id=2
select * from tablename
------------------------------------------------------
the value id=2 will be deleted in the tablename
-------------------------------------------------------
rollback transcation t
select * from tablename
---------------------------------------------------------
if u give rollback the deleted values will be seen again

Do you know how to send email from database?

926

---

How to stop a loop early with break statements in ms sql server?

973

---

What are the various editions of sql server 2017 that are available in the market?

844

---

How to create and drop temp table in sql server?

1002

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1079

---

what are the reporting service components in SSRS?

151

---

How can we determine what objects a user-defined function depends upon?

950

---

How to set database to be single_user in ms sql server?

967

---

What is the difference between count and distinct count?

842

---

What are the steps you must follow to hide sql server instances?

929

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

---

What is de-normalization and what are some of the examples of it?

923

---

Explain what is log shipping?

1073

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

958

---

What is the concept of optimization?

990

---