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

transform

1 Reply

  • del's avatar
    del
    Contributor III
    8 years ago

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

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