Microsoft SQL Server forum - Incorrect Syntax using IF statement

Author

Incorrect Syntax using IF statement

Fergatron

2006-04-06, 9:30 am

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

2006-04-06, 9:30 am

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

2006-04-06, 9:30 am

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'
==============

Sponsored Links