If you work with T-SQL stored procedures, you may have encountered situations where you need to store intermediate results in temporary tables or table variables. These are useful for breaking ...

There are several ways to hold intermediate data for processing in T-SQL. Derived tables could be looked at as temporary-views that exists for the duration of the execution of the outer query. Even ...

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.

There are various ways of using global variables in Microsoft SQL Server 2000 DTS Designer tasks. This article, one in a series, looks into their role in exchanging data between packages, using ...