i want to insert null values into table(i.e:suppose i am inserting 4 fields i that 2 fields is mandatory and rest of the fields is optional, in that optionsl places i want to insert null values one is string and second is long values), when i am trying this i am getting this error....
I presume the other two columns (they're not called fields in SQL) are NOT labelled "not null?"
Joined: Dec 21, 2006
I am inserting this values from UI, in Page i am filling values(mandatory fields fields and i don't want to rest of optional fields in that place i want to insert null values automatically).whatever you wrote that query will work fine for two fields.
The default value is null, anyway. You use the "default" clause if you want a column to receive a value other than null when inserting a row into a table and not specifying a value for that column. Or am I mistaken?