Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-05 : 16:16:10
|
Matt writes "I have noticed problems when it involves selecting more than one field that is a datatype of 'text'. I was running a query against a database, it was a simple SELECT with one WHERE condition, nothing fancy. The problem was I wasn't getting all of my data when I could clearly see in enterprise manager that it in fact did exist. A co-worker alerted me to a similar problem he had involving text datatypes. His problem involved a SELECT statement that had a text datatype but it was NOT the last item in his SELECT statement. He had repeated problems until he moved the text datatype to the last item in his select statement. Thinking that was weird, in my situation I decided to test my code by changing one of the datatypes from 'text' to 'varchar' as well as making sure my only 'text' datatype was selected last and indeed it worked! Could you shed some light on the mysterious ways of 'text' datatypes. We are running SQL 2000 on Win 2k Server.
Thanks,
Matt" |
|
|
|
|
|
Selecting More Than One Text Field