Post reply

Update

  • August 8, 2013 at 6:23 am

    #281679

    update #InwardTransDetails set Branch='BP66' where Branch='NG26' and logindate='2013-08-07'

    is not working why?

  • August 8, 2013 at 6:27 am

    #1639712

    By not working do you mean not updating any rows? If that is the case it would be because none of the rows have Branch='NG26' and logindate='2013-08-07'. If logindate column is a datetime it would not satisfy the where clause unless the time time part is exactly '00:00:00.000' so you might look at that.

    The probability of survival is inversely proportional to the angle of arrival.

  • August 8, 2013 at 6:31 am

    #1639714

    karunakar2351 (8/8/2013)

    update #InwardTransDetails set Branch='BP66' where Branch='NG26' and logindate='2013-08-07'

    is not working why?

    Is there an error?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 8, 2013 at 7:27 am

    #1639758

    Thanks

    i used convert

    now problem got solved

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

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