• table name :xyz coulumname is :submitdate datatype is : datetime

    Initially submitdate by default is null

    i updated the column for 100 orders to '02-02-2012 00.00.000'

    update xys set submitdate='02-02-2012 00.00.000' where id in ('1','2'.........'100')

    Now i want to revert back those 100 orders submitdate value to null .