|
|
Posted by Fergatron on 04/06/06 16:38
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.
Navigation:
[Reply to this message]
|