How can I restore a field back to Null?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dbuchanan
    #1

    How can I restore a field back to Null?

    Hello,

    I need to restore fields for records meeting a certain criteria back to
    null. Is there a way to do this in a stored procedure?

    dbuchanan

    Tags: None
    • dbuchanan
      #2
      Re: How can I restore a field back to Null?

      I figured it out.

      \\
      Update tbl040cmpt SET
      cmSmallint08 = cmSmallint05,
      cmSmallint04 = null
      FROM tbl040cmpt
      WHERE fkJob = 'd8779793-5f1a-4092-bad3-bf3ee5b50c3e'
      //

      dbuchanan

        Comment

        Previous template Next
        Working...