Yes, it is obvious for you but you suggested to do that and it wouldn't be easy to see for anyone.
Cetin
>Obviously.
>
>>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?