Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Reload this Page How to purposely create error?
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 9th, 2004, 02:08 PM
Registered User
  
Join Date: Dec 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to purposely create error?
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.
 
Old February 9th, 2004, 02:11 PM
Authorized User
  
Join Date: Jun 2003
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default
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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Error giving when i create the Subdomain Surjit Classic ASP Professional 0 April 18th, 2008 06:17 AM
Error - Cannot create a child list akibaMaila VB.NET 2002/2003 Basics 1 January 20th, 2005 04:15 PM
how to create an error page?? jthadathilm16 ADO.NET 1 May 1st, 2004 11:14 PM
how to create duplicate error message??? elleetan Access 1 September 16th, 2003 10:47 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.