Posted by rob on 10/27/71 11:57

Hugo,

Thanks for your reply.

Cheers,
Rob

Hugo Kornelis wrote:
> On 1 Sep 2006 06:05:01 -0700, rob wrote:
>
> >Hello,
> >
> >If I create a table with two columns of type "Text" will that cause any
> >issues? If my memory serves me correctly I thought I read a while back
> >that is it standard practice to only have one "Text" column per table.
>
> Hi Rob,
>
> You can have multiple text columns in a table.
>
> Of course, things will slow down if you fill all text columns with long
> texts, unless you exercise caution in your queries. And manipulating
> text data is terrible (consider moving to SQL Server 2005 and replacing
> text with the new varchar(MAX) datatype). But those are the standard
> problems with text columns.
>
> Adding a second text column doubles those problems, but dooesn't add
> extra issues.
>
> --
> Hugo Kornelis, SQL Server MVP

• Next in forum: specjalista od mssql2000 na jednorazowe zlecenie
• Prev in forum: Re: Server configuration for MSSQL 2000 and MSSQL 2005
• Thread view: Re: Text Column question

[Reply to this message]