Subject: How to purposely create error?
Posted By: funtent Post Date: 2/9/2004 1:08:54 PM
I've written a stored procedure and need to test the rollback statement:

IF @@ERROR > 0
   ROLLBACK TRANSACTION

Question: is there a function to cause an error?

Thanks in advance.

Reply By: hortoristic Reply Date: 2/9/2004 1:11:02 PM
Look up RAISERROR

_________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928  fax (360) 902-6200

Go to topic 9574

Return to index page 952
Return to index page 951
Return to index page 950
Return to index page 949
Return to index page 948
Return to index page 947
Return to index page 946
Return to index page 945
Return to index page 944
Return to index page 943