Which is preferable in MS SQL: NULL or empty string?

Question

SQL Server

Tell us about the pros and cons of using nullable fields in tables?
Maybe it's better to make all fields mandatory and write an empty string instead of NULL in empty ones?

Answer 1

It depends on the data in this field and only.

Answer 2

If English is OK, then here is a good discussion .

Answer 3

Also, don't forget that other operations start from scratch. Comparison, more, less, etc. do not fit him.

Answer 4

and when the data type is DateTime or int?