General information
Forum:
Microsoft SQL Server
Thank you very much for your answer Michael. I'll use .NULL. as default date as you suggest.
Alex
>>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?
>
>You'll get six spaces. A fixed length column backfills with spaces. Use a varchar or nvarchar column if you don't want this behavior.
>
>>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?
>
>You should be able to use a default of 0 or 0.00.
>
>>3) What date do you recommend to take the place of empty date fields?
>
>Personally, I'd allow NULLs in the column and use a NULL value when there is no date.
>
>-Mike
Previous
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