Post reply

How to use user-defined function without errors

  • April 2, 2003 at 4:15 am

    #175342

    If i have user-defined function with two parameters of SmallDateTime and i want to raise error if the first date is bigger than the second, what to do? I want to use a function for an update statement, for example.

  • April 7, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • April 7, 2003 at 1:35 pm

    #453392

    Use the RAISERROR function like this:

     

    if FirstDate > SecondDate

    RAISERROR ('The SecondDate must be bigger than de FirstDate',16,1)

  • April 8, 2003 at 1:08 am

    #453430

    Invalid use of 'RAISEERROR' within a function. I could not use RAISEERROR and a lot of other things inside a function.

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

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