Pages

Sunday, September 15, 2013

SQL SERVER – 2005 – List All The Column With Specific Data Types | Journey to SQL Authority with Pinal Dave

Since we upgraded to SQL Server 2005 from SQL Server 2000, we have used following script to find out columns with specific datatypes many times. It is very handy small script. SQL Server 2005 has new datatype of VARCHAR(MAX), we decided to change all our TEXT datatype columns to VARCHAR(MAX). The reason to do that… Continue Reading...

Source: SQL SERVER – 2005 – List All The Column With Specific Data Types | Journey to SQL Authority with Pinal Dave