Can we call SP inside a query?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
If we shrink the Databse and Files, how much size is decreased?
what are the joins,primary key,foriegn key, candidate key, super key and expain them?
Explain log shipping and mention its advantages.
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?
Show Practically Sql Server Views are updatable?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
Which are new data types introduced in sql server 2008?
What are the advantages of using third-party tools?
What is the cartesian product of the table?
What is trace flag in sql server?