Can we call SP inside a query?
Answer Posted / 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 |
Post New Answer View All Answers
How to create sub reports?
What is after dml trigger?
What is the need for group functions in sql?
How many columns can exist together per table?
How to connect a database with sql express.?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Do you know what is user defined datatypes and when you should go for them?
Explain indexed views?
What are the advantages to use stored procedures?
Explain view in sql server?
Do you know the cursor types?
What is self contained sub query?
Explain a join?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is the difference between NOROW and LOCKROW?