General information
Forum:
Microsoft SQL Server
Title:
Question about field defaults
Hi,
In order to minimize conversion issues from free tables I want to make the defaults for fields in SS table to be the same as free tables.
This leads to several questions:
1) If I set the default of a char(6) field as '', will the stored value be a string of 6 spaces or no spaces?
2) I upsize free table numeric fields as SS decimal fields of the appropriate precision and scale. Must I define such fields' default as 00000.00 (appropriate number of zeroes) or will 0 sufice?
3) What date do you recommend to take the place of empty date fields?
TIA,
Alex
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only