Results 1 to 2 of 2

Thread: Dumb Delete Question

  1. #1
    Join Date
    Jul 2005
    Posts
    14

    Dumb Delete Question

    If I want to just delete just the email address out of a row. How do I do that?

    ex. Delete User.Email
    Where ID = '0000'

    This statement doesn't work for me. Am I missing something

  2. #2
    Join Date
    Jul 2005
    Posts
    18
    "DELETE
    Removes rows from a table." - BOL

    Use UPDATE and SET the value to NULL, assuming your column allows for NULL values.

Posting Permissions

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