What is the difference between function and stored procedure in sql server?

0 Answers  

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  

---

How real and float literal values are rounded?

0 Answers  

---

What is co-related sub query?

0 Answers  

---

What is a data collection table?

0 Answers  

---

---

What is replication and database mirroring?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

What is log in sql server?

0 Answers  

---

Define Check points and End Points?

1 Answers  

---

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

---

What is BCP? When does it used in sql server 2012?

0 Answers   TryTechnicals Pvt Ltd,

---

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,

---