SQL Server 2000 - Default Value for varchar fields

Question

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?

Answer 1

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.