1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can we call SP inside a query?

Question Posted / srikanth

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

What is update locks?

0 Answers  

how many layers of tcp/ip protocol combined of? : Sql server database administration

0 Answers  

what are candidate key, alternate key and composite key? : Sql server database administration

0 Answers  

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

0 Answers   QuestPond,




What is mean by candidate key?

0 Answers  

What is difference between standardization and normalization?

0 Answers  

What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

What languages bi uses to achieve the goal?

0 Answers  

Find first and last day of current month in sql server

0 Answers  

For more SQL Server Interview Questions Click Here
Categories