If you pass a value for a column that takes precedence over default.
Cetin

>You can set DEFAULT constrain to an empty string for such columns in the SQL Server table.
>
>>I'm trying to use Doug Hennig's SQLXMLBulkLoad tool:
>>http://doughennig.blogspot.com/2006/07/sqlxmlbulkload-rocks.html
>>
>>to upload large tables to SQL server and keep getting the error message:
>>No data was provided for column 'memofield' on table 'tablename', and this column cannot contain NULL values.
>>
>>Now I could cheat and just allow NULL values on the field, but does anyone know how to get this to work when dealing with empty memo fields?