Tim,
Recently asked the same question regarding memo fields - specifically what
the equivalent was of an Access memo field in SQL Server. Here are two of
the many useful responses I received:
"It's TEXT. The Unicode version is NTEXT."
-and-
"text. Max storage per field is in the gigabytes.
Tho you might get away w/ varchar fields as the max varchar is 8000
chars vs. Access' meager 255 chars. Varchar is easier to deal with
for various reasons, so if you're under 8k, use the varchar instead
of text."
HTH,
Andy
----- Original Message -----
From: Timothy C. Hill <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Monday, October 16, 2000 10:25 AM
Subject: Re: SQL Server -> MS Access "Autonumber"
> When upgrading from an Access database, do you have to do anything other
> than click the identity field, or is there something else you need to do
> when you have records with a unique identity already in the table?? I am
> about to do the same thing, and I have always created my DB from scratch
in
> SQL.
>
> Are there any other snafus I need to watch for?? How about memo fields?
> Thanks,
>
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
