Hey guys I’m trying to find out how to send NULL to SQL, not a blank value but an actual NULL value; in this case to a date field. Here’s what I’m trying in my Non Query field:
‘… [My_Date] is NULL …’ which doesn’t work.
I haven’t seen any topics where people have found a solution for this yet
We shall see 
@cssc I think we have ourselves a solution!
Try using the Execute Query activity instead of the Execute Non Query Activity
Edit- NVM 
you are sending nulls - will re-attempt
Edit2- I was able to update rows where a null value was found in the [Preference] field - heres my query
“UPDATE [Forum-cssc].[dbo].[FoodPreferences]
SET [Preference] = ‘Unknown’
WHERE [Preference] is null;”
Before
After
Workflow
Locals Panel in Debug
Nevermind I found a simpler answer [My_Date] = NULL - basically just don’t use any quotes or anything like that and treat it like a normal update statement.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
