What is user stored procedure & it purpose?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / satish kanaujia
A stored procedure is a named group of SQL statements that
have been previously created and stored in the server
database. Stored procedures accept input parameters so that
a single procedure can be used over the network by several
clients using different input data. And when the procedure
is modified, all clients automatically get the new version.
purpose:
Stored procedures reduce network traffic and improve
performance. Stored procedures can be used to help ensure
the integrity of the database.
e.g. sp_helpdb, sp_renamedb, sp_depends etc.
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / ramanirajan das
A stored procedure is a named group of SQL statements that
have been previously created and stored in the server
database. Stored procedures accept input parameters so that
a single procedure can be used over the network by several
clients using different input data. And when the procedure
is modified, all clients automatically get the new version.
Because store procedure is pre complied so it need not compile
when u r doing some operation in procedure.
purpose:
Stored procedures reduce network traffic, secure and improve
performance. Stored procedures can be used to help ensure
the integrity of the database.
e.g. sp_helpdb, sp_renamedb, sp_depends etc.
Is This Answer Correct ? | 0 Yes | 0 No |
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??
What are three major types of constraints?
what is Buffer cash and Log Cache? Can you Explain it?
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform
what's the information that can be stored inside a bit column? : Sql server database administration
what is memory-optimized nonclustered indexes
Suggest a method of joining two tables.
0 Answers Ernst Young, Thomson Reuters,
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is the maximum size per database for sql server express?
Explain SELF JOIN ?
How to delete duplicate rows in sql server?
What is the default fill factor value?