"Edward Yang" <neo_in_matrix@msn.com> wrote in message
news:eE2dWdKaDHA.1748@TK2MSFTNGP12.phx.gbl...
> I found that if you do not include any effective SQL statement (excluding
> comment), SQL Server 2000 Query Analyzer will think it is an error:
>
> Server: Msg 156, Level 15, State 1, Line 6
> Incorrect syntax near the keyword 'end'.
>
> if 1=1
> select getdate()
> else
> begin
> --select 'ok'
> end
>
> Is this behavior a SQL standard?
>
>

> Oops! It seems there is no SQL guru to answer my simple
> question. :-(