What is the difference between functions and stored procedures?

0 Answers   Accenture,

---

How to genrate automaticlly empid like gt001

4 Answers  

---

What is the difference between a stored procedure and a user defined function?

0 Answers  

---

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

Explain use of expression builder.

0 Answers  

---

---

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

Can we insert data if clustered index is disabled?

0 Answers  

---

What are the difference between primary key and unique key? : sql server database administration

0 Answers  

---

What are synonyms?

0 Answers  

---

How to drop existing indexes in ms sql server?

0 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---