How to Change the Data Type of a Column Using T-SQL
There are some cases that you need to change the data type of a field in SQL Server by not using the Management Studio Tools. The reason is if your database is replicated. You cannot change it directly using the management studio tools so your best option is to use T-SQL.
In my case I have a column name “TransDate” that has a datetime datatype.
