Chapter 9 SQL Statements
581
PRINT statement [T-SQL]
Use this statement to return a message to the client, or display a message in
the message window of the database server.
PRINT
format-string
[,
arg-list
]
None.
None.
"MESSAGE statement" on page 568
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.
♦
SQL/92 Transact-SQL extension.
♦
Sybase Supported by Adaptive Server Enterprise.
♦ 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
Function
Syntax
Authorization
Side effects
See also
Description
Standards and
compatibility
Examples
To Next Page
Loading...