SP limitation ?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Agnes (agnes_at_dynamictech.com.hk)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 23:39:51 +0800

I got an if else statment in my SP
Create dbo..........etc

if ...............
  one long insert statment
  second long insert statment
else
 third long insert statment

[one & second insert statment , got 40 lines together]
For the above sytnax, I got" syntax error near ELSE] if I remove "ELSE",
there is no syntax error
OR if i remove the second insert statment, there is no error too. What
happend ???
Does my SP too large ?? Thanks

Relevant Pages

  • Re: invalid syntax
    ... I get an invalid ... >syntax error with this statment. ... I am sure I am missing parentheses somewhere ...
    (microsoft.public.access.formscoding)
  • Re: delete
    ... Jona Schuman wrote: ... The problem seems to have been a syntax error in a delete statment: ... The compiler doesn't know that you ...
    (comp.lang.cpp)
  • Re: invalid syntax
    ... >I am trying to set the status of certain deliverables. ... I get an invalid ... > syntax error with this statment. ...
    (microsoft.public.access.formscoding)
  • syntax error
    ... I get an invalid ... syntax error with this statment. ... I am sure I am missing parentheses somewhere ...
    (microsoft.public.access.gettingstarted)
  • invalid syntax
    ... I get an invalid ... syntax error with this statment. ... I am sure I am missing parentheses somewhere ...
    (microsoft.public.access.formscoding)