Forum Discussion

jomalladi's avatar
jomalladi
New Contributor
8 years ago

Update SQL Server

Hi All, I want to update a column with NULL (using SQL Update Snap) How can I pass DB Null to a column? I have tried passing in “null” that did not work. Please let me know if you have any ideas....
transform
del's avatar
del
Contributor III
8 years ago
Copy Link

Passing in null (without quotes) should work. The below example works for me.

{ "ID": 1, "col1" : "Test", "col2" : null }