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 differences between “row_number()”, “rank()” and “dense_rank()”?

533

---

What is parameterized reports in ssrs ?

105

---

Explain various data region available in ssrs with their use?

486

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1463

---

Can a table have 2 primary keys?

503

---

---

What is an sql server agent?

540

---

Explain the creation and execution of a user-defined function in the sql server?

570

---

How to retrieve error messages using odbc_errormsg()?

533

---

Do you know the isolation level that sql server support?

522

---

Determine how to use the inserted and deleted pseudo tables?

525

---

What is molap and its advantage? : sql server analysis services, ssas

537

---

List out the differences between global and local temp tables in sql server?

565

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

573

---

How to check if stored procedure is running in sql server?

475

---

How do clustered indexes store data?

605

---