I have this stored procdure
CREATE PROC dob.p_foobar
(
@foo bit = NULL,
@Bar bit = NULL
)
AS
IF @Foo == 1
BEGIN
SELECT 'Hello, World'
END
When I parse, I get the error "Incorrect syntax near '='".
Please tell me what I'm doing wrong. I know it's something stupid, but I just can't figure it out.
Thank you