SQL Server Performance Forum – Threads Archive

Data Types in SQL Server 2000

We are using MS SQL 2005 server for development purpose where where I have a table content field datatype varbinary(max) but I think (max) is not acceptable in MS SQL Server 2000. Our production server is MS SQL Server 2000. Could anybody tell me what is the similar datatype for varbinary(max) for MS SQL Server 2000. Regards

VARCHAR(MAX) replaces the TEXT data type. Only problem is that the TEXT data type has a lot of deficiencies such as not being able to group by it.

It depends on what for you are using Varbinary(max)…
If it is using for text then use TEXT datatype, if you are using for documents/images then use IMAGE datatype… Generally Varbinary(max) is used for documents/images…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

There is a section in SQL 2005 books online for changes in the data types, refer to them also. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

If you want to store files/images in server, refer this http://www.aspfaq.com/show.asp?id=2149 Madhivanan Failing to plan is Planning to fail

To avoid any hassles, I would set the comp level down to 8.0. Otherwise you might wonder why some features work in development, but not in production anymore. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP Contributing Editor, Writer & Forum Moderator<a target="_blank" href=http://www.sql-server-performance.com>http://www.sql-server-performance.com</a> Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>

]]>