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
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
Can you get second highest salary from the table?
What happens if we shrink log file in sql server?
What is the default order of an order by clause?
Explain concepts of analysis services?
What is unique key constraint?
What are different types of statements that are supported by sql?
How you can change a cross join into an inner join?
what is a self join? : Sql server database administration
How to rebuild indexes with alter index ... Rebuild?
Why use stored procedures in sql server?
Explain how many normalization forms?
Why we use functions in sql server?
What are character string data types in ms sql server?
What is the usage of sign function?