Link to home
Start Free TrialLog in
Avatar of jj819430
jj819430

asked on

Insert Null into sql??

Hey so I have a sql insert string we'll say:
Insert INTO FooTable (val1,val2,val3) values (@val1,@val2,@val3)

I go through and add the parameters.
Now when adding the values, that can depend on what is read by the application. The problem is if the value is null.
if it is null I want to have the database be null. But the requirement for this null changed from when I originally built the app, so I can't have it dynamically create the string. Basically I want to know if I can have the value = null?

ASKER CERTIFIED SOLUTION
Avatar of testn
testn

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial