title: Converting a table Colum from datetime2 to datetime
body: <p>I have been assisgned with a starnge assigment where i need to convert 40 tables columns from datetime2 to datetime.</p>
  
  <p>this is the datetime format what i am having in my database.2007-11-12 00:00:00</p>
  
  <p>it contains more than 90,000 records</p>
  
  <p>Please assist</p>