Answer Posted / monal

Yes you can call function from stored procedure, so far i
haven't had a chance to use it, but still would like to give
it a shot:
As per my guess you can call function in SP using select
statement as you would execute function usually.

What are the kinds of subquery?

1006

---

What is the purpose of the master database?

1115

---

What do you understand by user-defined function in the sql server?

945

---

Is null in sql server?

980

---

What is Extended user-defined?

953

---

What is the difference between DATETIME2 and DATETIME?

1070

---

What are different types of join?

1304

---

Explain about local stored procedure?

962

---

How to change the system date and time from SQL Plus Terminal ?

1213

---

What is role playing dimension with two examples? : sql server analysis services, ssas

996

---

What are the different types of join?

1163

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1016

---

What is sql server used for?

1038

---

Explain foreign key in sql server?

1016

---

What are the new data types are introduced in sql 2000?

895

---