How to provide values to stored procedure parameters in ms sql server?

0 Answers  

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

Why functions are used in sql server?

0 Answers  

---

What is the user of Primary key?

0 Answers  

---

What is the default sql server instance name?

0 Answers  

---

How is table type constraint applied to a table?

0 Answers  

---

What is attribute? : sql server analysis services, ssas

0 Answers  

---

where the connection string store in the database

0 Answers   HCL, Wipro,

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

optimization techinques

0 Answers   Wipro,

---