SQL Server 2000 - Default Value for varchar fields

sql, sql-server, sql-server-2000

Solution

The default is a blank (empty) string.

If you don't provide a value, the insert will be successful and the value will be blank, not null.

Problem

I have a sql server nvarchar field with a "Default Value or Binding" of empty string. It also happens to be a not null field. Does this mean that there is no default or that it is a default of a string with no characters in it. If I don't insert a value, will it insert with an empty string or fail with a "not null" error?

Original source