Posted by diego on 01/07/07 05:54

Thank you.

Ayon kay Plamen Ratchev:
> You can use GOTO. It will look like this:
>
> query statements
> if condition
> begin
> query statements
> GOTO ExitQuery
> end
>
> query statements
> if condition
> begin
> query statements
> GOTO ExitQuery
> end
>
> ExitQuery:
> GO
>
> Be aware that GOTO cannot go to a label outside of the batch.
>
> Regards,
>
> Plamen Ratchev
> http://www.SQLStudio.com
>
> "diego" <diegobph@yahoo.com> wrote in message
> news:1168144191.844124.221930@11g2000cwr.googlegroups.com...
> > Greetings everyone!
> >
> > Is there a way to stop query analyzer from processing remaining query
> > statements? Let's say i have the following query in query analyzer:
> >
> > query statements
> > if condition
> > begin
> > query statements
> > stop the query
> > end
> >
> > query statements
> > if condition
> > begin
> > query statements
> > stop the query
> > end
> >
> > is there a way to stop the query from executing the statements in the
> > second query when the first condition is met?
> >
> > i have searched BOL and google but i couldn't find anything. I hope
> > anybody out there can help me.
> >
> > BTW, i'm executing this statements directly in QA, not from within my
> > program. The query statement and if condition pair is plenty. i guess i
> > can use an else statement but it would be nested too deep. if there is
> > a simpler way to do it please point me to the right direction or to any
> > link that'll get me going.
> >
> > Thanks in advance.
> >
> > diego
> >

• Next in forum: Re: Idea: new database object that defines a FROM clause
• Prev in forum: Link Server doesn't work except through query analyzer: MSSQL freezing / timing out
• Thread view: Re: How to stop query in QA from continuing

[Reply to this message]