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

What do you mean by normalisation?

1028

---

What is the difference between left and right outer join?

1056

---

How to find index size for each index on table?

997

---

What is policy based management (pbm)? : sql server database administration

975

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

902

---

Which are the two editions in which SQL Azure database available?

119

---

Explain microsoft sql server functions?

1102

---

How to make conditional sum in ssrs?

177

---

When would you use a before or after trigger?

902

---

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?

1012

---

How to enable tcp/ip protocol on a sql server?

1154

---

How to replace given values with null using nullif()?

981

---

What is trace flag in sql server?

1013

---

Why union all is faster than union?

906

---

Explain various data region available in ssrs with their use?

925

---