How to stop query in QA from continuing

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.

diegoYou 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.comwrote in message
news:1168144191.844124.221930@.11g2000cwr.googlegro ups.com...

Quote:

Originally Posted by

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
>

|||Thank you.

Ayon kay Plamen Ratchev:

Quote:

Originally Posted by

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.comwrote in message
news:1168144191.844124.221930@.11g2000cwr.googlegro ups.com...

Quote:

Originally Posted by

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

|||You could also use "RETURN".

-Dave
http://www.markleconsulting.com
diego wrote:

Quote:

Originally Posted by

Thank you.
>
Ayon kay Plamen Ratchev:

Quote:

Originally Posted by

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.comwrote in message
news:1168144191.844124.221930@.11g2000cwr.googlegro ups.com...

Quote:

Originally Posted by

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
>