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:51 am

    #1526989

    ChrisM@Work (8/17/2012)

    HowardW (8/17/2012)

    This sounds a really simplistic question, but based on what you've said, it should just be:

    update xys set submitdate=NULL where id in ('1','2'.........'100')

    I feel I must be missing something as surely if you know how to set the rows to one value, you know how to set it to another...

    If I could find an emoticon for perplexed, it would be right here!

    Let me guess: OP has closed the window with the list of real id's he updated

    ... where id in ('1','2'.........'100')

    Now he tries to get it back from us...

    My question was: would the query SELECT * FROM orders WHERE SubmittedDate = '20120202' return 100 records or else?

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]