Home Forums SQL Server 2008 T-SQL (SS2K8) how to change the date value to null?? RE: how to change the date value to null??

  • August 17, 2012 at 3:16 am

    #1526969

    Lavanyasri (8/17/2012)

    hi ,

    I have a column with date datatype. i updated the column with some date like 02-02-2012 00.00.000 ,for 100 orders Now i want to change the value for those 100 orders to NULL . how can i change ???

    Thanks

    lavanya

    Looks like a datetime datatype?

    Do any orders other than the 100 you've just changed have the same value in the column?

    Do you have auditing columns on the table (e.g. LastModifiedDatetime, LastModifiedBy)?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden