How can I restore a field back to Null?

  • Thread starter Thread starter dbuchanan
  • Start date Start date
D

dbuchanan

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
 
I figured it out.

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

dbuchanan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Dates and Null Handling 4
counting Null fields 3
how to work with null data in vb.net 2005 5
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
What are the steps to fix damaged MDF files in SQL Server? 0
How to insert a record with a stored procecure 2
How to add new records to the top of the DataGrid 2
How to handle nulls in this expression? 7

Back
Top