HELP!---Stored Procedure in ASP -- sql server odbc

Edgardo Valdez, MCSD, MCDBA
4/3/2006 11:09:28 AM

on 1. you can use the following

if (SELECT count(*) from tblX01 where [your condition]) = 0
insert into tblX02

you can add the 2. part after it

Let me know if it answers what you asked...

[quoted text, click to view]

Jack Jackson
4/3/2006 11:21:18 AM

On Mon, 3 Apr 2006 13:37:17 -0400, "segis bata"
[quoted text, click to view]

If you don't care how many records exist:

IF NOT EXISTS(SELECT ?? FROM TABLE ....)
INSERT ....
ENDIF

If you need to know how many exist:

DECLARE @cnt int

segis bata
4/3/2006 1:37:17 PM

Hello everyone,

I'm writing you because I need help in something that's taking too long. =
I want to build a Stored Procedure to be accessed by an ASP page and I =
need that Stored Procedure to do a couple of things:
1.. Depending on parameters sent by the ASP page, do a SELECT =
statement to a table (tblX01) and if it returns ZERO records, the SP =
should insert some info into other table (tblX02) and if returns ONE =
record, it won't insert into tblX02
2.. Insert some other info in another table (tblX03)
With #2 I don't have a problem, is with #1, how do I know the select =
statement returns ZERO or ONE record? how do I capture that value in the =
Stored Procedure?

Thanks for your prompt response,

Bob Barrows [MVP]
4/3/2006 2:05:54 PM

[quoted text, click to view]
IF EXISTS (SELECT * FROM tblX01 WHERE ...)
BEGIN
INSERT INTO tblX02 ...
END

HTH,
Bob Barrows

PS. Please don't crosspost to so many groups. sqlserver.programming was the
only really relevant group, although .asp.db would have been all right as
well, despite the fact that the question was answerable without even
mentioning asp.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Bob Barrows [MVP]
4/3/2006 3:27:04 PM

[quoted text, click to view]
??
Are you sure you are talking about SQL Server?
True, the OP did not mention which database he was using, but judging from
the newsgroups in his crosspost ...

To the OP: it is always a good idea to tell us the type and version of
database you are using ...
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Jack Jackson
4/3/2006 5:20:04 PM

On Mon, 3 Apr 2006 15:27:04 -0400, "Bob Barrows [MVP]"
[quoted text, click to view]

I, like you, assumed the poster wanted a SQL Server stored procedure.
My code is exactly like yours, except yours did not say NOT EXISTS
which is what I think he wanted.

Or maybe you thought I meant to actually put the ?? in the SELECT
statement - I didn't, I intended that to be a place where he would put

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server odbc

sql server odbc : HELP!---Stored Procedure in ASP