Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Interrupt Procedure

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-03-19 : 15:21:03
Hello,

Is it possible to interrupt a procedure on a condition?

For example:
If a=0
STOP my procedure and don't run any more code.

Thanks,
Miguel

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-19 : 15:24:48
Use RETURN to exit the stored procedure.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -