Thread: erron handling
View Single Post
  #2 (permalink)  
Old April 10th, 2006, 03:44 PM
Jeff Mason Jeff Mason is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

There are a number of invalid statements in this stored procedure definition:

1. What's that SELECT doing there all by itself after the AS clause?

2. What are all those LOG... lines doing after the single line comment -- TODO...?

3. What is that DECLARE crslog ... statement doing? It is certainly not declaring any datatype (e.g. CURSOR, etc).

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com