Learn More. In this, Part 4 of a series on programming T-SQL, Gregory Larsen details how to set variables in calling T-SQL code while using sp_executesql.

If a variable is able to be declared, it should have the functionality to be passed as necessary. I was thrilled to learn that SQL Server 2008 offers this functionality.

My pet peeve has always been pretty-printing, but that's another story. In fact, even modular variables, in class-based programming, should give way to properties.