Stored Procedure Execution with Parameters, Variables and Literals

less than 1 minute read

As I’m working more and more with stored procudures it’s always useful to go back to basic and learning about parameters, variables and literals from Kimberly L. Tripp is great way to start. In the SQL Server land you need consider performance, I probably wouldn’t use variables which seem to be the biggest problem. Like the best articles if you read through it you’ll find more gems and Building High Performance Stored Procedures looks like another must read, especially as the example looks exactly like something I’ve been writing.

Leave a Comment