PRINT

Remarks

Use PRINT to print variable values or constants. The PRINT statement applies only to Windows-based platforms. It is ignored on other operating system platforms.

You can use PRINT only within stored procedures.

Examples

The following example prints the value of the variable :myvar.

PRINT( :myvar );   

PRINT 'MYVAR = ' + :myvar;

The following example prints a text string followed by a numeric value. You must convert a number value to a text string to print the value.

PRINT 'Students enrolled in History 101: ' + 
convert(:int_val, SQL_CHAR);   

See Also

CREATE PROCEDURE