Can we call SP inside a query?

Answers were Sorted based on User's Feedback



Can we call SP inside a query?..

Answer / sachin

We can't call sp inside query insted we can call Function
inside query,infact that is the major difference between
the SP and Function

Is This Answer Correct ?    45 Yes 0 No

Can we call SP inside a query?..

Answer / rajasekaran

no we can't call SP inside a query

Is This Answer Correct ?    21 Yes 6 No

Can we call SP inside a query?..

Answer / 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

Can we call SP inside a query?..

Answer / radhakrishnan

No, we can't call sp in query.

Eg:this query not working properly

select empno,empname,exec spname
from tablename.

but function we can call with in a query.

Eg:

select empno,empname,upper(empaddress)
from emptable

Is This Answer Correct ?    7 Yes 0 No

Can we call SP inside a query?..

Answer / mohammed

Yes we can

Is This Answer Correct ?    5 Yes 41 No

Post New Answer

More SQL Server Interview Questions

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,


what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,


Explain log shipping and mention its advantages.

0 Answers  


what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,


can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,






How do I find the sql server version?

0 Answers  


Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,


How to get a list of columns using the "sp_help" stored procedure in ms sql server?

0 Answers  


Which are new data types introduced in sql server 2008?

0 Answers  


What are the advantages of using third-party tools?

0 Answers  


What is the cartesian product of the table?

0 Answers  


What is trace flag in sql server?

0 Answers  


Categories