Post reply

syntax error

  • January 6, 2017 at 1:11 am

    #339190

    There is syntax error in the code.

    Incorrect syntax near 'id='.

    INSERT INTO LOG_RATE_MONTH(LOG_MESSAGE,LOG_DATE)('id='+@_prev,getDate());

    @_prev is a sql variable

    whats the issue in this code ?

  • January 6, 2017 at 1:21 am

    #1921040

    spectra (1/6/2017)

    There is syntax error in the code.

    Incorrect syntax near 'id='.

    INSERT INTO LOG_RATE_MONTH(LOG_MESSAGE,LOG_DATE)('id='+@_prev,getDate());

    @_prev is a sql variable

    whats the issue in this code ?

    Missing the VALUES keyword

    😎

    INSERT INTO LOG_RATE_MONTH(LOG_MESSAGE,LOG_DATE) VALUES('id='+@_prev,getDate());

  • January 6, 2017 at 1:24 am

    #1921041

    Thanks....This worked excellent.

  • January 6, 2017 at 1:56 am

    #1921047

    spectra (1/6/2017)

    Thanks....This worked excellent.

    You are very welcome

    😎

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

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