Can we call SP inside a query?

Answer Posted / aagstya

No We can not call SP inside any query! We can call only
function in query.
This is the major difference in between SQL Function and
SQL Stored Procedure

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql server query analyzer?

507


What is data compression?

545


What are the dis_advantages of stored procedures, triggers, indexes?

1685


Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

518


Can we insert data if clustered index is disabled?

506






what data regions are and what are the different data regions?

101


How do I open a .db file?

478


How can we check the sql server version?

558


Write a sql query to get zero records from a table having n number of records?

705


How do I schedule a sql server profiler trace?

538


Detail about the hardware which is supported by SQL server?

582


What is left outer join in sql server joins?

549


What is SQL Azure Firewall?

116


What are the parts of a function?

521


What is a database table?

517