Question SQL Server column data type

tqmd1

Well-known member
Joined
Dec 5, 2009
Messages
60
Programming Experience
Beginner
Dear SIR,
I am using sqlserver2005.
Table1 has a column named bill_no and its type is text
Now I want to change its type "Numeric"
When I do this the it displays this error message

---------------------------
Microsoft SQL Server Management Studio
---------------------------
Conversion from 'text' to 'numeric' is not supported on the connected database server.

How to change type text to numeric
I do not want it through vb.net codes.
I want to apply it directly in sqlserver 2005.

Please help
 
Back
Top