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
Explain logical operators in sql server?
What is the cartesian product of the table?
Explain data warehousing in sql server?
Do you know the different ddl commands in sql?
can you instantiate a com object by using t-sql? : Sql server database administration
How do I view a procedure in sql server?
What are the new features are introduced in sql server 2012 reporting services?
What is the difference between a stored procedure and a user defined function?
What is plan freezing?
What is sparse columns of sql server 2008?
What is normalization? Describe its different types.
Explain the categories of stored procedure?
What are a scheduled jobs?
Mention the uses of stored procedures.
How do you delete a trigger?