Create procedure to check and save email address

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Create procedure to check and save email address

Author

Topic

imughal
Posting Yak Master

192 Posts

Posted - 2011-07-25 : 07:02:08

Hi,

i want to create a procedure to pass email address as input, check email address in table if exist return already exist text of not save email address in table and return save.

pls guide.

i m using ms sql server 2008.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-07-25 : 07:11:16

If exists(select * from table where emial=@email)
select 'already exists'
else
insert into table(col) select @email
select 'saved'

Madhivanan

Failing to plan is Planning to fail

imughal
Posting Yak Master

192 Posts

Posted - 2011-07-25 : 07:32:24

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE gbs_newslettersubscription
@UserEmailAdd VARCHAR(100)
AS
BEGIN
SET NOCOUNT ON;
If exists(select NewsletterEmail from GBS_Newsletter where NewsletterEmail=@UserEmailAdd)
select 'already exists'
else
insert into GBS_Newsletter(NewsletterEmail) select @UserEmailAdd
select 'saved'

END
GO

this is my procedure

i am calling like that
execute gbs_newslettersubscription "myemailaddress@hotmail.com" but its return two window after calling in management studio if email exist if not exits it save and return one window so pls tell is is correct or i am doing somethig wrong

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-07-25 : 07:39:26

quote:
Originally posted by imughal

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE gbs_newslettersubscription
@UserEmailAdd VARCHAR(100)
AS
BEGIN
SET NOCOUNT ON;
If exists(select NewsletterEmail from GBS_Newsletter where NewsletterEmail=@UserEmailAdd)
select 'already exists'
else
insert into GBS_Newsletter(NewsletterEmail) select @UserEmailAdd
select 'saved'

END
GO

this is my procedure

i am calling like that
execute gbs_newslettersubscription "myemailaddress@hotmail.com" but its return two window after calling in management studio if email exist if not exits it save and return one window so pls tell is is correct or i am doing somethig wrong

Multiple lines for ELSE should be in Begin and End block


CREATE PROCEDURE gbs_newslettersubscription
      @UserEmailAdd VARCHAR(100)
AS
BEGIN
      SET NOCOUNT ON;
      If exists(select NewsletterEmail from GBS_Newsletter where NewsletterEmail=@UserEmailAdd)
		select 'already exists'
		else
Begin
			insert into GBS_Newsletter(NewsletterEmail) select @UserEmailAdd
		select 'saved'
End             
           
END
GO

Madhivanan

Failing to plan is Planning to fail

imughal
Posting Yak Master

192 Posts

Posted - 2011-07-25 : 07:45:31

thx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources