How to Print a Dynamic SQL Statement
- 1). Create a variable to hold the dynamic SQL statement. To define a variable in SQL, use the following code:
declare sql nvarchar(250)
This variable holds a dynamic statement with a maximum 250-character limit. - 2). Set up the the dynamic SQL statement. In this example, the dynamic SQL statement retrieves the first record in the customer table:
set sql = 'select top 1 from customer' - 3). Print the statement to the console. SQL has a "print" function that prints the statement directory to the programmer's console. This is seen each time the SQL statement is run. Use the following code to print the dynamic SQL statement:
print sql
