Answer Posted / jeetu

Function can be used inside the queries but Store procedure never used inside the queries For Example Given below:

select avg(salary) from employee;// allowed here

avg(): is function

Select sp(salary) from employee // Not allowed here

sp(): is stored Procedure

Thanks

Explain aggregate functions?

1083

---

Do you know what is a with(nolock)?

1057

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1064

---

What is SubQuery in SQL Server 2008

1023

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1066

---

What is database white box testing?

1122

---

What is a mutating table error and how can you get around it?

1051

---

What is key attribute?

935

---

What happens if you add a new index to large table?

942

---

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

945

---

Explain primary key, foreign key and unique key?

994

---

What are the differences between ms sql server & oracle?

1062

---

Explain what is lock escalation?

1066

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1033

---

Does index speed up select statements?

1012

---