>I have a memo field for inventory item description information and
>need to save it in SQL Server.
>
>What data type/length should I use in SQL Server ????
>
>Any other ideas, I must have at least enough space for 2 or 3 pages
>of information for each item--so all I can think of using is a memo.
>
>Thanks in advance !!!!!
You use a Text datatype, but its a real space hog. Each non NULL value takes at least one 2K page. Plus you must initialize a text column. The Transact SQL Reference has a pretty good section on the Text datatype.
HTH.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement