By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,843 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,843 IT Pros & Developers. It's quick & easy.

Incorrect Syntax using IF statement

P: n/a
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.

Apr 6 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
SQL
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/

Apr 6 '06 #2

P: n/a
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'
==============

Apr 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.