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.