IF ELSE Query

Question

IF ELSE Query

latingntlman

SSCarpal Tunnel

Points: 4348
More actions
July 19, 2013 at 1:35 pm

#276134

I have written an IF ELSE statement into a sproc but I'd like to display the results (as in counts) from the statement in the "Results" pane after the sproc runs. How do I accomplish this?
IF EXISTS ({SELECT Query})
BEGIN
{INSERT Version 1}
END
ELSE
BEGIN
{INSERT version 2}
END
Thx.
John

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183698 More actions · Answer 1

Do you just want to know how many rows were inserted? You could consider @@ROWCOUNT or the OUTPUT clause.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Voide Mr or Mrs. 500 Points: 548 More actions · Answer 2

To obtain data from a stored procedure you need to have a select. A function can 'return' data if that's what you're looking for-- If you're looking to return something based on some condition.

Below is an extremely basic example of selecting data from a temp table in a SProc

declare @Table_A Table (--Table Column Names and cast types)

--if conditions

insert into @Table_A

--else conditions

insert into @Table_A

select columnNameWithResults from @Table_A

kapil_kk SSC-Insane Points: 21316 More actions · Answer 3

I am not clear with your requirement..can you please some more detailed information to us.......

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

latingntlman SSCarpal Tunnel Points: 4348 More actions · Answer 4

Correct, Luis.

I wanted to see how many records were inserted.

Luis Cazares SSC Guru Points: 183698 More actions · Answer 5

latingntlman (7/22/2013)
Correct, Luis.
I wanted to see how many records were inserted.

Then you could simply use

SELECT @@ROWCOUNT

Beware of the possible resets of the @@ROWCOUNT value.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 6

Voide (7/19/2013)
To obtain data from a stored procedure you need to have a select. ...[/code]

The OUTPUT clause of a DELETE will do just fine 😉

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden