explain query execution plan

1 Answers  

---

Mention a few common trace flags used with sql server?

0 Answers  

---

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

What are the differences between stored procedure and the dynamic sql?

0 Answers  

---

---

What are the general features of sql server management studio? : sql server management studio

0 Answers  

---

what is difference between primary key and Unique

8 Answers  

---

What is a field name?

0 Answers  

---

What are the differences between decimal and float in ms sql server?

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,

---

What are group functions in query statements in ms sql server?

0 Answers  

---

What are page splits?

0 Answers  

---