bulkinsert - sql server bulk insert and temporary tables -

-

ive been learning mysql decided have attempt @ sql server. have pasted code mysql sql server , figuring out parts of code need adapted work in sql server. trying create temporary table , bulk insert text file temporary table. statement works fine in mysql show:

    create temporary table test123     (     reason_t varchar(30) default null,     month_t varchar(30) default null,     year_t varchar(30) default null,     week_type_t varchar(30) default null,     accident_time_t varchar(30) default null,     alcohol_level_t varchar(30) default null,     age_t varchar(30) default null,     gender_t varchar(30) default null);      load data local infile 'c:\\users\\jon\\onedrive\\desktop\\roadsafety_test123.txt'       table test123      fields terminated ','      lines starting '' terminated '\r\n'      ignore 1 lines;

and in sql server have far come this:

    declare @test123 table     (     reason_t varchar(30) default null,     month_t varchar(30) default null,     year_t varchar(30) default null,     week_type_t varchar(30) default null,     accident_time_t varchar(30) default null,     alcohol_level_t varchar(30) default null,     age_t varchar(30) default null,     gender_t varchar(30) default null);      bulk insert test123   'c:\\users\\jon\\onedrive\\desktop\\roadsafety_test123.txt'      (  fieldterminator =',', firstrow = 2, rowterminator = '\n');

the query in sql server not work however, temporary table actions don't seem straight forward mysql , im struggling find relevant information regarding it. did aswell try creating test123 table standard create table statement insert still got error 4863 age_t column in test123, far data goes see no problems , works fine in mysql.

i'm sure have missed obvious or done wrong way round said have never used sql server before can't find definitive answers.

you should provide @ least few lines of file use import, might others pinpoint causing error. :)

bulk insert test123 'c:\\users\\jon\\onedrive\\desktop\\roadsafety_test123.txt' (fieldterminator =',', firstrow = 2);

just idea, try removing "rowterminator = '\n'" part of code. bulk insert in sql server treats "end-of-line" default row terminator. , read somewhere windows text files uses different end-of-line symbols, cr lf, mark end of row. though can't find reference, can see opening text file notepad++, click view tab, show symbol, ticking show end-of-line.


Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more