Is that true that if we use SetNull() to a nullable decimal field ,it goes as 0.00 in to database???I really felt wierd when most of the people said that.
You have to not mention a column in your DML for the default value to be used, setting it to null will cause it to be null regardless of the default. That's true for Oracle and I'm assuming other databases as well.
-craig
"You can never have too many knives" -- Logan Nine Fingers
In DB2 it depends how the DBA has set it. There are conditional values on inserts as well.
Test it out as Craig mentioned. Drop the records in a dataset or flat file and see what the values are. If it shows up null there then there is something on the database side.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
thanks all for your replies..I am getting NULLs in database.I was confident enough but the counters were many.Hence I posted but yes it is my fault to post it before testing on my own