All geek questions in one place

Convert text to varchar (MAX)

I am currently working on a SQL Server project that was created for SQL Server 2000. Some of the tables in this project used a data type Text. Since some big changes are needed for this database, it would be nice to change these fields to VARCHAR(MAX). All SQL servers are now 2005 and 2008.

Are there any problems expected when I change all data types Textto VARCHAR(MAX)or all functions supported by the type Textare also supported VARHCHAR(MAX).

As additional information, data from the database is requested mainly from the .net application, in addition, it is also available, as well as access to some statistical tools and access to the database directly through odbc / ole-db.

+3
source share
1 answer

Source: https://habr.com/ru/post/1783599/

More articles:


All Articles