| 1 | How does SQL Server compile and cache execution plans for stored procedures, and how does this affect performance compared to ad hoc queries? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Advanced |
| 2 | What are the main differences between a stored procedure and a function in terms of what each one can and cannot do? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Intermediate |
| 3 | What is a stored procedure in SQL Server, and what are the main benefits of using one? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Beginner |
| 4 | How do you use output parameters in a stored procedure to return a value back to the calling code, in addition to or instead of a normal result set? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Intermediate |
| 5 | What is the difference between using EXEC and calling a stored procedure through parameterized application code, and why does this distinction matter for security? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Intermediate |
| 6 | How would you design a stored procedure to handle a complex business process involving multiple steps, proper error handling, and transaction management together? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Advanced |
| 7 | What is the difference between a scalar function and a table valued function in SQL Server? SQL Server › Stored Procedures & Functions | SQL Server | Stored Procedures & Functions | Beginner |
| 8 | What restrictions exist on what a user defined function is allowed to do compared to a stored procedure? SQL Server › User Defined Functions | SQL Server | User Defined Functions | Intermediate |
| 9 | What are natively compiled stored procedures, and how do they work together with memory optimized tables? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Intermediate |
| 10 | What is a user defined function in SQL Server, and why would you create one instead of repeating the same logic in multiple queries? SQL Server › User Defined Functions | SQL Server | User Defined Functions | Beginner |