Posted by Hugo Kornelis on 09/01/06 21:03

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

[Back to original message]