Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2006
    Location
    CA
    Posts
    210

    Unanswered: What is the keystroke in Enterprise Manager for Null?

    In MS Sql Server 2000 Enterprise Manager, how do I set the column value back to $null?

    I've tried Google searches and MSDN, just can't find it. However; I knew it and used it 3 years ago; alas poor memory and lack of use has deleted the trick. Maybe someone here knows it.

    Thank you very much, in advance.
    Last edited by vich; 11-11-06 at 03:52.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    What's wrong with using:

    UPDATE theTabel SET theColumn = NULL;

    (btw: $null is not a NULL value for the database)

  3. #3
    Join Date
    Mar 2004
    Posts
    162
    is ctrl + 0 to set a cell to NULL what you looking for?

  4. #4
    Join Date
    Oct 2006
    Location
    CA
    Posts
    210
    Quote Originally Posted by mrpcguy
    is ctrl + 0 to set a cell to NULL what you looking for?
    Thank you, that's it!

    Many many thanks! Had a few goofs lately and cursed my failing memory for having to take the long way around!



    Quote Originally Posted by shammat
    What's wrong with using:

    UPDATE theTabel SET theColumn = NULL;

    (btw: $null is not a NULL value for the database)
    $null, <null>, so many languages and platforms, "use what I mean, not what I say" and all that. Anyway, the UPDATE statement, besides being subject to disasterous where-clause error some late night, is many keystrokes distant vs. being right there in the EM GUI.

    It's a quick "oops" fixer when in the GUI. If you type in the wrong column (ie: <null> is appropriate), then your alternative is either to let the update take place then go out and issue an UPDATE in another tool, exit the window prior to allowing the update to take hold (possibly loosing your recordset that my no longer be recoverable), or doing Ctrl/0.

    So; this is not only much quicker, but has less risk of momentary bad data, or at least a quicker fix-up and return to <null>.
    Last edited by vich; 11-13-06 at 14:53.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    modifying data in EM....

    I feel like I have to take a shower now
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Oct 2006
    Location
    CA
    Posts
    210
    Quote Originally Posted by Brett Kaiser
    modifying data in EM....

    I feel like I have to take a shower now
    Haha.

    Actually; just this morning I was in there doing it. But thank you for your critisizm.

    The value of doing Update and Create statements for everything is to apply to test environments first and for saving an audit trail.

    My situation is a development environment where I'm tweaking the design on the fly. My brain just isn't able to visualize a perfect layout on paper, sorry. Also setting up and resetting test data easiest in a GUI.
    Last edited by vich; 11-14-06 at 18:21.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •