Can we call SP inside a query?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / srikanth

5 Answers
10416 Views
CA, CarrizalSoft Technologies, Wipro, I also Faced
E-Mail Answers

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