Õâ¸ö¿ÉÒÔÏÞÖÆÔö³¤ Äĸö¿ÉÒÔÏÞÖÆÔö³¤£¿ ÎÒÔÏÈÉèÖõÄÊǼòµ¥ ͬÒâ,²»ÖªµÀ»¹ÓÐÆäËûʲô·½·¨ use twfy go Truncate table ybdata_new go BULK INSERT ybdata_new from 'd:\ybdata.txt'WITH(FIELDTERMINATOR='\t',ROWTERMINATOR='\n',MAXERRORS=3) go
delete Ò½±£¶ÔÓ¦±í where itemtype = 'TJCJYPXX' or itemtype = 'TJCJZLXX' go INSERT INTO Ò½±£¶ÔÓ¦±í (itemtype,itemnoyb,itemnameyb,itempym,itemmemoyb1,itemmemoyb2,itemmemoyb3,itemmemoyb4,itemmemoyb5,itemmemoyb6,itemmemoyb7,itemmemoyb8,itemmemoyb9,itemmemoyb10,itemmemoyb11,itemmemoyb12,itemmemoyb13,itemmemoyb14,itemmemoyb15,itemdatayb1,itemdatayb2,itemdatayb3,itemdatayb4,itemdatayb5,itemdatayb6,itemmemoyb17,itemmemoyb16) sel