IF...ELSE error

[Hannibal111111]

Hi,

I am trying to print out a statement if a record is not found, but I
keep getting Error 156: incorrect syntax near Else. Here is the stored
procedure:

CREATE PROCEDURE AddUpdateDoorStyles

(
@myprojectid varchar(255),
@doorstyle varchar(255)
)

AS

IF EXISTS (select *
from myproject_doorstyles
where myproject_id = @myprojectid and door_style = @doorstyle)
ELSE
Print 'test'

GO

Any ideas?

Thanks,

Chris

[akej via SQLMonster.com]

>Any ideas?
CREATE PROCEDURE AddUpdateDoorStyles

(
@myprojectid varchar(255),
@doorstyle varchar(255)
)

AS

IF EXISTS (select *
from myproject_doorstyles
where myproject_id = @myprojectid and door_style = @doorstyle)

Print 'ok'
ELSE
Print 'notOK'
----------------
or u can use

IF NOT EXISTS (select *
from myproject_doorstyles
where myproject_id = @myprojectid and door_style = @doorstyle)

Print 'notOK'


GO

--
Message posted via http://www.sqlmonster.com

[Erland Sommarskog]

(Ha************@hotmail.com) writes:

I am trying to print out a statement if a record is not found, but I
keep getting Error 156: incorrect syntax near Else. Here is the stored
procedure:

CREATE PROCEDURE AddUpdateDoorStyles

(
@myprojectid varchar(255),
@doorstyle varchar(255)
)

AS

IF EXISTS (select *
from myproject_doorstyles
where myproject_id = @myprojectid and door_style = @doorstyle)
ELSE
Print 'test'

IF ELSE with nothing in between is not permitted in T-SQL, so you need
to put in some dummy statement or change EXISTS to NOT EXISTS:
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp