Top "Raiserror" questions

SQL Statement Termination using RAISERROR

(SQL 2005) Is it possible for a raiserror to terminate a stored proc. For example, in a large system we've got …

sql sql-server-2005 triggers raiserror

RAISERROR―How to distinguish with SqlException?

I have some 3-4 stored procedures ― which I can modify if needed ― that use RAISERROR to inform my application of …

c# wcf sql-server-2005 sqlexception raiserror

Formatting RAISERROR messages in SYBASE ASE 12.5

In a stored procedure, I am trying to test if a parameter is null or less then 1, and if so, …

sql stored-procedures sap-ase raiserror

RAISERROR within Case statement

Can you not raise errors within a case statement in T-SQL? I always have problems with SQL case statements :/ begin …

tsql case raiserror

Detecting for invalid file inputs, Python

I have an assignment to write a Python script which "detects whether the file is readable or not". I am …

python input raiserror

RAISERROR from Catch Block in TSQL Passed to Calling Batch - Need that Passed to Calling Application

I have been researching the TRY/CATCH block and I am a little stumped on how to pass an error …

sql tsql sql-server-2005 try-catch raiserror

IF, RAISERROR & RETURN in Stored Procedure

I have a stored procedure, PROC, which receives some parameters. If one of them, @ID, is not null, a given …

sql-server-2005 stored-procedures return raiserror