Convert Varchar to Int Data type in sql server

Question

1.44/5 (2 votes)

See more:

SQL-Server-2008

Hello iam using sqlserver 2008.
Iam having table1 with studentid column as int.And another table table12 with same studentid column as id.Now i have to move the data from table1 to table2.Before dat i need to check whether the data in table1 is integer or not.If it is integer,i need to allow it to table2.

I have tried isnumeric(studentid),it is accepting float also like 10.0
I tried with convert(studentid,int),throwing error :cannot convert from varchar to int.

Thanks for any help

Posted 14-Nov-13 20:06pm

njdcjk

Add a Solution

Comments

Siva Hyderabad 15-Nov-13 2:09am

u want to copy the table1 to table2 yes?

njdcjk 15-Nov-13 2:15am

yes,but my datatypes are different.So i need to accept only int in table 2

Siva Hyderabad 15-Nov-13 2:18am

create procedure like this..
insert table2 select * from Table1 where sno=@Sno

njdcjk 15-Nov-13 2:24am

Ya,in procedure only iam dng but how can i pass @sno.Is there any way to check from table1

1 solution

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-11-14T20:10:00

This question reflects one of the biggest fallacies of the beginners these days: a trend to work with strings representing data instead of data itself. If you need to have integer values in some columns, use some numeric, integer data types, not varchar. See, for example:
http://technet.microsoft.com/en-us/magazine/dd424925.aspx[^].

—SA