You can also specify a file containing initialization SQL commands by setting environment variable: INIT_SQL_COMMANDS_FILE to the path of the file containing the SQL commands - example value: ...

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.

You can join to a UDF. Using table variables SQL Server 2000 has a new Table data type that lets you declare local variables as type table. The table type is available only via a UDF.

You can also specify a file containing initialization SQL commands by setting environment variable: INIT_SQL_COMMANDS_FILE to the path of the file containing the SQL commands - example value: ...