Text Column question

[rob]

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.
Any input would be appreciated.

Thanks,
Rob Panosh

[Hugo Kornelis]

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

[rob]

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