What are the triggers in sql?

0 Answers  

---

What is Trigger?

3 Answers   Misys,

---

How to create logins using windows Authentication mode?

2 Answers  

---

explain different types of joins? : Sql server database administration

0 Answers  

---

What is the difference function and stored procedure?

0 Answers  

---

What is the difference between join and inner join?

0 Answers  

---

Define views.

0 Answers  

---

What are joins in sql and what are the different types of joins?

0 Answers  

---

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

---

What is a trigger and its types?

0 Answers  

---

What is an index. What are the types?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---