conversion of data type from nvarchar to numeric

Question

0.00/5 (No votes)

See more:

SQL-server-2000

I am trying to change the data type of a column from nvarchar to numeric by using following query:-

SQL

alter table grimage alter column tbb numeric(10)

but i got the following error :-

Error converting data type nvarchar to numeric.<br />
The statement has been terminated.

Posted 7-Mar-13 23:21pm

ashwani.pandita

Updated 8-Mar-13 9:02am

Maciej Los

v2

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Davidduraisamy · Answer 1 · 2013-03-08T00:52:00

Solution 2

Hi,

Check the values in that column because String might be stored so it cant convert the values...If it so then update the values and change.

Posted 8-Mar-13 0:52am

Davidduraisamy

shivammpi123 · Answer 2 · 2013-03-08T00:55:00

Solution 3

Hey have u checked the table values if not please check your table values first.Youtr table has some text values defiantly so first remove them after that you can alter your table...

Posted 8-Mar-13 0:55am

shivammpi123

Updated 8-Mar-13 0:56am

v2

MalwareTrojan · Answer 3 · 2013-03-08T00:57:00

Solution 4

To change the data type of Column, it should be empty.

Posted 8-Mar-13 0:57am

MalwareTrojan

itsmehaboob · Answer 4 · 2013-03-07T23:38:00

Solution 1

did you checked the tables values?

the table have nvarchar values first u delete those values and try again...

Posted 7-Mar-13 23:38pm

itsmehaboob

Comments

Davidduraisamy 8-Mar-13 6:57am

No need to delete the values..He can update the string values to numeric...Thats enough..

itsmehaboob 8-Mar-13 7:28am

how can you convert string value to numeric?
e.g. (a to numeric)

Maciej Los · Answer 5 · 2013-03-08T09:13:00

Steps to do:
1) add new column

SQL

ALTER TABLE grimage ADD COLUMN tbbnum NUMERIC(10)

2) copy data to new column

SQL

UPDATE grimage SET grimage.tbbnum = t1.tbbnum
FROM grimage INNER JOIN
    (
    SELECT CONVERT(NUMERIC(10), t1.tbb) AS tbbnum FROM grimage
    ) AS t1 ON grimage.id = t1.id

3) remove unused column

SQL

ALTER TABLE grimage DROP COLUMN tbb

That's all!