Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ORDER BY on ntext works on some SQL server installs?!?
The error is the standard MS error as described above and in the server manual. It throws the error correctly in the two cases since this shouldn't work. I'm positive the field is ntext and that in the one instance the sorting actually work. It was all tested multiple times. The question is why...- kutyafal
- Post #3
- Forum: Microsoft SQL Server: Programming
-
ORDER BY on ntext works on some SQL server installs?!?
I'm using the SQL Query Analyzer to test a simple query: SELECT * FROM maintable ORDER BY ntextfield ntextfield is type ntext. The servers are SQL 2000 developer edition, SQL 2000 Desktop Data Engine and SQL 2000 Enterprise. All three has SP2 installed. Dev. Ed. is installed on Win2000 SP3...- kutyafal
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
