Interested to Buy Any Domain ? << Click Here >> for more details...
Can we call SP inside a query?
- 5 Answers
- 10417 Views
- CA, CarrizalSoft Technologies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to create view in stored procedure sql server?
What are SSL and TSL protocols?
Explain optimistic and pessimistic concurrency?
What is built-in function?
What is attribute relationships, why we need it? : sql server analysis services, ssas
Give an example of why you would want to denormalize a database
What are the different types of upgrades that can be performed in sql server?
What is merge?
How you would rewrite the sql query to return the customerid sorted numerically?
Where cross join is used?
Mention the different types of triggers?
Where in ms sql server is ’100’ equal to ‘0’?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Do you know how to implement service broker?
