How to create stored procedures with parameters in ms sql server?

0 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

---

What are different types of views?

0 Answers  

---

What is inline variable assignment?

0 Answers  

---

---

Why should one not prefix user stored procedures with ‘sp_’?

0 Answers  

---

What is the syntax for encrypting a column in SQL Server?

0 Answers   MindCracker,

---

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,

---

Can we use where clause in union?

0 Answers  

---

Difference between group by clause and having clause in SQL?

0 Answers   Flextronics,

---

What languages bi uses to achieve the goal?

0 Answers  

---

Can you tell me about the concept of ER diagrams?

0 Answers  

---