PRINT statement [T-SQL]

Returns a message to the client, or display a message in the database server messages window.

Syntax

PRINT format-string [, arg-list ]

Remarks

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 in the database server messages window.

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

Privileges

None.

Side effects

None.

Standards

ANSI/ISO SQL Standard
Not in the standard.

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