Showing posts with label filled. Show all posts
Showing posts with label filled. Show all posts

Tuesday, March 20, 2012

change datatype of a column

what is the best (and fast) why to change a column's datatype from varchar to decimal ?
the table has 3 million records and the column is filled with data (no problem with converting the data to numeric).alter table tablename
alter column columnname float null|||tnx