DB2 guy here, about to begin a conversion project...
I wonder if someone could answer a question about column defaults when creating a table. In DB2, to create a default constraint, the value of the default does not have to be specified in the create:
CREATE TABLE MYTABLE(
COMMENT CHAR(200) NOT NULL WITH DEFAULT);
In this case, DB2 will insert blanks (by default) when a row is inserted without a comment.
Does MSSQL have similar functionality, or must the default value of a CHAR, VARCHAR, INT, etc, always be included in the CREATE statement?
Thanks a million,