Microsoft SQL Server 2005 Console Write Line

Is there a way to write a message to the console? I'd like to write some de开发者_如何学JAVAbug data if it's possible.

The PRINT command emits a message that may be shown in a console depending on what tool you're using:

PRINT 'Hello, world!'

Not all clients necessarily show these messages though.

You mean PRINT?

For example:

PRINT 'hello world'

For long-running operations, instead of PRINT, you might need to use the RAISERROR with NOWAIT option workaround, since the messages display is cached.

Higher overhead but you can log to the event logging system with xp_logevent.