Changing Column Types in a Table

Changing column types in a table
SQL Server does not permit you to explicitly change the datatype or length of a column. But there is a trick to get around this. You can use the convert function to redefine the datatypes. For example, if a columnname were defined with a length of 10 and you wanted to change it to length of 100, you would do this:

 select convert(varchar(100), columnname) columnname, ...into DB1..TABLE1from DB2..TABLE2

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: