Interested to Buy Any Domain ? << Click Here >> for more details...
Can we call SP inside a query?
- 5 Answers
- 10598 Views
- CA, CarrizalSoft Technologies, Wipro, I also Faced
- E-Mail Answers
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 |
What is sub query and its properties?
What is difference between inner join and full join?
Tell me what is the difference between locking and multi-versioning?
What factors you will consider calculating the storage requirement for that view?
Explain about protocol layer present in SQL server?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Do you know what is a trace frag? Where do we use it?
Explain about SQL server 2005?
When would you use a before or after trigger?
why we use cursor?
4 Answers CarrizalSoft Technologies, Melstar, TCS,
Difference between primary key and clustered index?
Explain the database you used in your final year project?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
