Reading csv files and importing data into SQL Server -

-

i'm reading numbers .csv file sql server below statement, assuming i've created linked server named csv_import.

select *  csv_import...sophos#csv

however, problem if have comma numbers data, show null instead of correct one. how can read "54,375" correctly sql server? thank help.

below data in csv file.

09/07/2017,52029,70813,10898,6691,6849,122,25,147427 09/08/2017,47165,61253,6840,5949,5517,75,2,126801 09/14/2017,"54,375","16944","15616","2592","3280",380,25,"96390"

this result statement:

2017-09-07 00:00:00.000 52029   70813   10898   6691    6849    122 25  147427 2017-09-08 00:00:00.000 47165   61253   6840    5949    5517    75  2   126801 2017-09-14 00:00:00.000 null    16944   15616   2592    3280    380 25  96390

one way go using temporary table. read data text, replace every comma in whole table dot (.), if want decimal separator, or empty string('') if it's thousand separator, load data exisitng table converting (you don't have explicitly, sql implictly).


Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more