How can I change the data type from varchar to numeric

Published by: Rose (2/2/2009 4:54:25 PM)

I have a table which holds data of 10000+ records. There is data type of a column that needed to be changed from varchar to numeric. I tried various means to achieve this but failed in all. Please let me know an easy way to fix this problem.

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

How do I start SQL Server 2008 Services >>

<< How do I Update the Records of Multiple Tables having Same Column Name in One Query