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