Post reply

pass the multiple query in single IF statement

  • August 13, 2008 at 2:35 pm

    #382240

    hi

    I am getting the following error while executing the program.

    Incorrect syntax near the keyword 'else'.

    declare @id as int

    set @id=5

    if(@id>2)

    print 's'

    print 'b'

    else

    print 'r'

    Any Ideas?

  • August 13, 2008 at 3:08 pm

    #857738

    You need a BEGIN/END around the statements between your IF and ELSE.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • August 13, 2008 at 4:21 pm

    #857769

    it's working.

    thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply