Post reply

Stored procedures error.

  • May 13, 2007 at 12:20 pm

    #195725

    Hi friends, I am facing a different issue.

     

    While compiling a stored procedure from the batch file (through isql/osql command),its compiled successfully but while executing it giving error.

     

    But while compiling the stored procedure manually in isql window, it executing fine without errors.

     

    Please explain me why the same stored procedure working like that.

    Regards,
    S e n t h i l

  • May 13, 2007 at 9:05 pm

    #706083

    Don't use ISQL.exe for any batch process... it is severely deprecated... use OSQL.exe instead.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 13, 2007 at 9:50 pm

    #706087

    Would be extremley useful to know what the error is

     

     

    --------------------
    Colt 45 - the original point and click interface

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

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