SQL Server Interview Questions and Answers What is store procedure? How do they work? When do you use? A stored procedure is a collection of SQL statements that has been created and stored in the database. It is a set of recompiled SQL statements that are used to perform a special task. Stored procedures create once a time and calls it n number of times and also reduces the network traffic and increase the performance. When do you use store procedure? I used store procedures in 1 of 3 scenarios, · Security, · Speed and · Transactions Types of SQL Procedures, 1. System Stored Procedures 2. User Defined Stored Procedures 3. Extended Stored Procedures Syntax:-...