Environment & System Variables - Embedding Parameters in SQL Code

Using Environment Variables in SQL Code

After Environment Variables are created, they can be referenced in SQL code. To use them, you must follow the format <$VariableName$> in the SQL code. For example, the figure below shows code that uses the LinkedServerName and TableOwner variables. Please refer to the section Introduction to Environment Variables for more information.

Figure 102.14:  Using Environment Variables in SQL Code.

© 2001-2018 JNetDirect, Inc. All Rights Reserved.