Why use update_statistics command in sql server?

0 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,

---

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 the basic functions for master, msdb, model, tempdb and resource databases?

0 Answers  

---

---

What is a non clustered primary key?

0 Answers  

---

What is a mixed extent?

0 Answers  

---

How to use “drop” keyword in sql server and give an example?

0 Answers  

---

How to invoke a trigger on demand?

0 Answers  

---

Explain the creation and execution of a user-defined function in the sql server?

0 Answers  

---

diffrence between function and procedure

5 Answers   Wipro,

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---