Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
what is the primary use of the model database? : Sql server administration
What is indexing explain it with an example?
Explain error and transaction handling in sql server?
How to verify a user name with sqlcmd tool?
What is indexed view?
What is the default value of an integer data type in sql server 2005?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is the difference between row_number and dense_rank?
List some case manipulation functions in sql?
How to insert multiple rows with a subquery?
How each E-R model constructs can be mapped to the relational model?
What is used to replicate sessions between instances in coldfusion clusters?
What is difference between oltp and olap?
How to create an index on a view?
