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
Which Model uses the SET concept
How to create a new login name in ms sql server?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is data source in connection string?
What is dynamic cursor in SQL SERVER?
What is merge statement?
How to create stored procedures with parameters in ms sql server?
How can we get count of the number of records in a table?
What is the use of toad or sqldbx.?
What is the temp table?
What is the use of stored procedure?
What is database architecture? : SQL Server Architecture
What are the types of sql server?
Can coalesce return null?
how we use window authentication connection with sql server.?
