BULK INSERT hais kom nrawm dua bcp lossis cov ntaub ntawv twj tso kua mis los ua cov ntawv sau ua haujlwm, txawm li cas los xij, BULK INSERT nqe lus tsis tuaj yeem luam cov ntaub ntawv los ntawm SQL Server mus rau ib qho. cov ntaub ntawv. Siv cov khoom siv bcp hloov DTS thaum koj xav tau xa tawm cov ntaub ntawv los ntawm SQL Server lub rooj rau hauv cov ntawv nyeem.
Dab tsi yog qhov txawv ntawm bulk insert thiab BCP?
BULK INSERT yog SQL hais kom ua thiab BCP yog cov khoom siv cais tawm sab nraud SSMS thiab koj yuav tsum tau khiav BCP los ntawm DOS sai (command prompt). BULK INSERT tuaj yeem luam cov ntaub ntawv los ntawm cov ntaub ntawv tiaj tus mus rau SQL Server lub rooj whereas BCP yog rau ntshuam thiab xa tawm ob qho tib si. … BCP muaj kev sib cais tsawg dua thiab raug nqi ntau dua BULK INSERT.
Puas BCP nrawm?
Kev luam cov ntaub ntawv hauv, bcp nrawm tshaj yog tias koj lub rooj database tsis muaj qhov ntsuas. Txawm li cas los xij, yog tias koj siv ceev ceev bcp los ua cov ntaub ntawv ntxig, uas ceev bcp tsis kaw, koj tsis tuaj yeem rov qab (khoom pov tseg) cov ntawv teev npe rau ib lub cuab yeej.
Vim li cas bulk insert yog ceev?
In case of BULK INSERT , tsuas yog qhov kev faib faib tau teev tseg es tsis yog cov ntaub ntawv tiag tiag inserted . Qhov no yuav muab kev ua tau zoo dua li INSERT. Qhov txiaj ntsig tiag tiag, yog txhawm rau txo tus nqi ntawm cov ntaub ntawv raug nkag rau hauv kev sib pauv log.
Puas ntau tsim sai dua?
Bulk insert yog txoj kev nrawm tshaj plaws los thauj cov ntaub ntawv rau hauv SQL Server, tshwj xeeb tshaj yog tias nws tau nkag tsawg kawg nkaus. Cov ntaub ntawv tuaj yeem tsuas yog cov ntawv nyeem xwb.
