What's the equivalent of Postgres' RAISE NOTICE in SQLServer 2005?

Question

I am looking to output a message from a function in MS SQL 2005 when executed from the sql server management studio, similar to Postgres' RAISE NOTICE.

Answer 1

You can raise errors with RAISERROR, or print messages with PRINT. You should look these up in Books Online.

Answer 2

It would be RAISERROR in SQL Server

Answer 3

To add to the other answers, you may want to read through these great articles:

Error Handling in SQL 2005 and Later

Answer 4

The direct translation may be RAISERROR, but SQL Server 2005 now supports TRY/CATCH blocks

BEGIN TRY
BEGIN TRANSACTION TestTransaction

INSERT INTO tbBlah
(
    SomeColumn
)
VALUES
(
    5
)

COMMIT TRANSACTION TestTransaction
END TRY

BEGIN CATCH
    ROLLBACK TRANSACTION TestTransaction
END CATCH