Sunday, July 17, 2011

SQL Datatypes

I was wondering about all the data types that are available during table creation in SQL server 2008 R2 Express. After searching (not very hard) I found this from Personal Notes of Pinal Dave 
“Yes, VARCHAR(MAX) is big enough to accommodate TEXT field. TEXT, NTEXT and IMAGE data types of SQL Server 2000 will be deprecated in future version of SQL Server, SQL Server 2005 provides backward compatibility to data types but it is recommanded to use new data types which are VARHCAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX).”


An important piece of information don't you think.

No comments:

Post a Comment