I have a table of 1000 records in sql server 2008 that I migrated from an MS access database used as a backend.. The dates are showing up as text in MS access front end connected to the sql back end table.
Solution is to convert the date fields in the SQL server table that have datatype =datetime2 to the datatype called smalldatetime. This is proven to work with a few records testing.
Can you please write the code to convert all 1000 records to new datatype.
Our db administrator does not know how and has tryed CAST , ALTER to no avail so we need the exact code.