>>>>No. It's a result of SQLEXEC command.
>>>
>>>Then in the method where you add record REPLACE default values :-)
>>
>>How? I want to replace with the defaults from the database. In other words, looks like we need to bring the defaults for the columns in a separate statement...
>>
>>All sounds quite tricky, but as I examined our tables yesterday, I found that we're not using defaults.
>
>
>sp_columns 'NamerOfTheTable'
>
>And check Column_Def column.
Can you get this info by a different method? I wanted to test every table in DB just to see if either table has defaults (I think here we're not favoring defaults).
If it's not broken, fix it until it is.
My Blog