Yes, TRY…CATCH can use the RAISEERROR function. A developer said I never showed it, so here are simple SQL Server 2005 examples with and without it.
SQL SERVER – Find Name of The SQL Server Instance
SELECT @@SERVERNAME returns the name of the SQL Server instance. We used it in stored procedures that ran different logic on each server during a migration.
SQL SERVER – 2005 – OUTPUT Clause Example and Explanation with INSERT, UPDATE, DELETE
The SQL Server 2005 OUTPUT clause returns the rows changed by INSERT, UPDATE or DELETE. Each OUTPUT clause example below shows how.
SQL SERVER – Two Connections Related Global Variables Explained – @@CONNECTIONS and @@MAX_CONNECTIONS
@@CONNECTIONS and @@MAX_CONNECTIONS explained: login attempts since SQL Server started versus the most simultaneous user connections allowed.
SQL SERVER – Introduction and Example for DATEFORMAT Command
I found DATEFORMAT in a Jr. DBA’s code. SET DATEFORMAT sets the order of month, day and year so SQL Server can read date strings in other formats.
SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT
What is the effect of a TRANSACTION on local variable values after ROLLBACK and after COMMIT? A short example I wrote for a Jr. Developer shows the answer.







