Update SQL Server

#1

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. Appreciate all your help!

#2

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

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