Incorrect Syntax using IF statement

[Fergatron]

Hi,

I'm new to SQL Server Programming, I work with ASP a lot, but lately
I've been trying to create Stored Procedures, etc. I'm having a
problem writing a simple IF statement.. I don't seem to understand why
it's giving me this error. I've search around on Google Groups, but I
still don't get it.

=============== ==
USE msdb

IF NOT EXISTS (SELECT * FROM sysjobs WHERE name = 'Scheduled Nightfax')

END
=============== ==

My error is:
Server: Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'END'.

Thanks for any help.

[SQL]

Re: Incorrect Syntax using IF statement

you need a BEGIN for every END
example

DECLARE @v BIT
SELECT @v = 1

IF @v = 1
BEGIN
select 'yes'
END
ELSE
BEGIN
select 'No'
END


Or without begin...end
IF @v = 1
select 'yes'
ELSE
select 'No'

Denis the SQL Menace

http://sqlservercode.blogspot.com/

[Fergatron]

Re: Incorrect Syntax using IF statement

Thanks, I played with it a bit and I got the result I was looking for.

==============
USE msdb
DECLARE @JobName varchar(255)
SELECT @JobName = name FROM sysjobs WHERE name = 'Scheduled Nightfax'

IF @JobName = 'Scheduled Nightfax'
PRINT 'YES'
ELSE
PRINT 'NO'
==============