ASA SQL Reference
  SQL Statements

PRINT statement [T-SQL]

Description 

Use this statement to return a message to the client, or display a message in the message window of the database server.

Syntax 

PRINT format-string [, arg-list]

Usage 

The PRINT statement returns a message to the client window if you are connected from an Open Client application or jConnect application. If you are connected from an embedded SQL or ODBC application, the message is displayed on the database server window.

The format string can contain placeholders for the arguments in the optional argument list. These placeholders are of the form %nn!, where nn is an integer between 1 and 20.

Permissions 

None.

Side effects 

None.

See also 

MESSAGE statement

Standards and compatibility 

• SQL/92    Transact-SQL extension.

• SQL/99    Transact-SQL extension.

• Sybase    Supported by Adaptive Server Enterprise.

Example 

The following statement displays a message:

PRINT 'Display this message'

The following statement illustrates the use of placeholders in the PRINT statement:

DECLARE @var1 INT, @var2 INT
SELECT @var1 = 3, @var2 = 5
PRINT 'Variable 1 = %1!, Variable 2 = %2!', @var1, @var2