Posted on: 5/12/2011 2:34:52 PM | Views : 329

Hi,
I am using SQL Express from VS2010 (SQL 2010 R2)
I have a table with 2 DateTime columns and I would like to change there types.
Column1 from DateTime to Date (the conents are all dates with 00:00 for the time portion), Column2 from DateTime to Time (whatever dates can be dropped). I have tried going through the Designer and of course it fails...
Is there a quick method to change these column types?
SquireDude ...

Go to the complete details ...