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 to create dbo table in sql server?
List the types of recovery model available in sql server?
What are the functions in sql server?
Can You Use Data Mining Models In Ssrs?
what is isolation level at dead lock?
What is it’s similarity with sql server?
What Are the Main Features of SQL Azure?
What is the use of builtinadministrators group in sql server? : sql server security
Explain how to use linked server?
explain different types of cursors? : Sql server database administration
Explain the properties of the relational tables?
What is difference between rownum and rowid?
‘Order by’ is not allowed in a view how can you sort information from a view?
What is exporting utility?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
