sql invalid queries from a csv file

Question

i have imported all of the data from a csv named animal data. I can query with select * (where i get the following results)

https://i.sstatic.net/evzjv.jpg

but when i try to query the following

select ["Max Weight"]
from dbo.animaldata
where ["Max Weight"] > 5

Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'NA' to data type int.

select ["Sex"]
from animaldata
where ["Sex"] = "male"

Msg 207, Level 16, State 1, Line 3
Invalid column name 'male'.

Can anyone please tell me what am i doing wrong in both counts?

Hello again. i tried the query that you have posted but i got the following error:

Msg 245, Level 16, State 1, Line 9
Conversion failed when converting the varchar value 'NA' to data type int.

instead i used the following and it did produce the same results (381 rows):

 select ["Max Weight"]
from dbo.animaldata
where ["Max Weight"] > '5' AND  ["Max Weight"]!='N/A'

select ["Max Weight"]
from dbo.animaldata
where ["Max Weight"] > '5'

The problem is solved and i will leave it for future reference. Regards Panos

Regards Panos

Volk · Accepted Answer · 2014-11-16 11:45:31Z

2

1) You got value "NA" in column "Max weight". So Sql server can not convert it to int.

2) Should be where ["Sex"] = 'male'

answered Nov 16, 2014 at 11:45

Volk

464 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dudi Konfino · Accepted Answer · 2014-11-17 12:21:00Z

0

  select ["Max Weight"]
from dbo.animaldata
where ["Max Weight"]>5 AND  ["Max Weight"]!='N/A'

answered Nov 17, 2014 at 12:21

Dudi Konfino

1,1242 gold badges13 silver badges24 bronze badges

1 Comment

Arvo Over a year ago

Doesn't help. You can use CASE statement however.

Collectives™ on Stack Overflow

sql invalid queries from a csv file

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related