Answer Posted / arunyadav007
There are two type of stored procedures. System Stored
Procedure and User Stored Procedure (User Defined Stored
Procedure).
User SProcs serves the same purpose as the system SProcs.
Now the question comes what is the need to write a stored
procedure?
Suppose in your organization there are certain queries
which are used very frequently or there are certain queries
in which you don't want users to know that what all tables/
views etc. are scanned to get the desired result or, for
faster execution of a frequently used query you write
stored procedures.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Which table keeps information about stored procedures?
Explain use of expression builder.
How to enforce security in sql server? : sql server security
What is built-in/administrator?
Scalability, Availability, Integration with internet, etc.)?
How will you make an attribute not process? : sql server analysis services, ssas
Explain a join?
What is a performance monitor?
What is unique key constraint?
Explain the working of sql privileges?
What are the components of dbms?
How self join is different from outer join?
What is lock escalation and what is its purpose?
What is user-defined inline table-valued function?
Where is my database stored on the hard disk in ms sql server?
