Stored Procedures Questions and Answers

Why do stored procedures reduce network traffic?

When a stored procedure is called, only the procedure call is sent to the server and not the statements that...
What are stored-procedures? And what are the advantages of using them.

Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound...
What is stored procedure?

Stored procedure is a group of SQL statements that forms a logical unit and performs a particular task. Stored Procedures...
What is the advantage of using stored procedure over the SQL queries ?

Writing the SQL statements inside our code is usually not a good idea. In this way you expose your database...
Can you have a nested transaction ?

Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK, SAVE TRAN and @@TRANCOUNT

What is an extended stored procedure?

Can...
How can I return from within a T-SQL the list of all available character sets and code pages ?

You can use the xp_enumcodepages undocumented extended stored procedure to return the list of all available character sets and code...
How do I report information about the active locks ?

To report information about the active locks, you can use the sp_lock system stored procedure. Read about the sp_lock stored procedure...
What is normalization ?

Well a relational database is basically composed of tables that contain related data. So the Process of organizing this data...
What is a DATABASE trigger ?

What is a DATABASE Procedure ?

A DATABASE TRIGGER is a stored procedure associated with a table that ORACLE7 automatically executes on one or more specified...
How can I return from within a T-SQL the list of server’s hard drives ?

You can use the xp_fixeddrives undocumented extended stored procedure to return the list of all hard drives and the amount...