Importing thiab Exporting SQL neeg rau zaub mov cov ntaub ntawv los ntawm kev hais kom ua kab nrog Bcp

Bcp yog txoj kev ceev tshaj plaws uas tau txais cov ntaub ntawv mus rau hauv ib lub database

Tej daim luam (bcp) hais kom ua ntawm Microsoft SQL Server muab koj cov peev xwm los ntxig cov coob ntawm cov ntaub ntawv khaws tseg los ntawm cov kab hais kom ua. Tsis tas li ntawd, yog ib qho tseem ceeb rau kev siv kab-kev hais ua ke, lub chaw tso dej bcp yog lub cuab tam siv rau cov neeg nrhiav kev nkag mus rau hauv SQL neeg rau zaub mov ntawm cov ntaub ntawv hauv cov ntaub ntawv los sis lwm txoj kev. Muaj ntau txoj hauv kev kom tau txais cov ntaub ntawv rau hauv ib lub database, tab sis bcp yog qhov ceev tshaj plaws thaum nws teeb nrog txoj cai tsis.

bcp Syntax

Lub ntsiab syntax rau kev siv bcp yog:

bcp

qhov twg cov lus muab cov nram qab no qhov tseem ceeb:

• Table_name yog lub npe tsim nyog ntawm lub rooj. Piv txwv, tej zaum koj yuav siv cov khoom npe ntawm cov khoom siv rau cov txiv hmab txiv ntoo los ntawm tus tswv tsev database hauv cov khoom database.
• Kev qhia qhia tau hais tias koj xav import ("hauv" kev taw qhia) lossis xa tawm ("tawm" kev qhia).
• File_name yog kev puv npo rau cov ntaub ntawv. Piv txwv, koj tuaj yeem xa cov ntaub ntawv C: \ fruit \ inventory.txt.
• Cov kev tso cai pub koj qhia kom tsis txhob muaj kev ua haujlwm ntau. Piv txwv li, koj tuaj yeem qhia meej txog qhov ntau ntawm qhov uas tau tso cai nrog qhov kev xaiv -m. Koj kuj tseem siv tau qhov -x kev xaiv kom pom tseeb XML hom ntawv. Ntsib Microsoft lub bcp cov ntaub ntawv rau ib daim ntawv teev tas nrho.

bcp ntshuam piv txwv

Muab tag nrho ua ke, xav txog tej yam koj muaj ib lub rooj txiv hmab txiv ntoo hauv koj cov lus nug database thiab koj xav import tag nrho cov ntaub ntawv los ntawm ib phau ntawv cia rau hauv koj lub zog tsav mus rau qhov database ntawd. Koj yuav siv cov lus sib dhos bcp hais kom ua nram qab no:

bcp inventory.dbo.fruits hauv "C: \ fruits \ inventory.txt \" -c -T

Qhov no ua rau cov zis nram qab no:

C: \> bcp inventory.dbo.fruits hauv "C: \ txiv hmab txiv ntoo \ / inventory.txt \" -c -T Pib luam ... 36 natwm theej. (Pob): 4096 Sij hawm (ms.) Tag Nrho: 16 Nruab nrab: (2250.00 natwm ib ntu) C: \>

Tej zaum koj yuav tau pom ob txoj kev xaiv tshiab rau qhov kev hais kom ua. Lub -c xaiv qhia meej tias cov ntaub ntawv hom ntawm cov ntaub ntawv ntshuam yuav yog tab-delimited text nrog txhua cov ntaub ntawv rau ib kab tshiab. Kev xaiv-T yog qhia tias bcp yuav tsum siv qhov tseeb ntawm Windows kom txuas mus rau lub database.

bcp Export piv txwv

Koj tuaj yeem xa cov ntaub ntawv tawm ntawm koj tus database nrog bcp los ntawm kev hloov cov kev khiav haujlwm ntawm "hauv" mus rau "tawm." Piv txwv, koj tuaj yeem muab cov khoom ntawm cov ntawv txiv hmab txiv ntoo tuaj rau ib phau ntawv nrog rau cov lus qhia nram no:

bcp inventory.dbo.fruits tawm "C: \ fruits \ inventory.txt \" -c -T

Ntawm no yog li cas uas zoo li ntawm cov kab hais kom ua:

C: \> bcp inventory.dbo.fruits tawm "C: \ txiv hmab txiv ntoo \ / inventory.txt \" -c -T Pib luam ... 42 natwm theej. (Pob): 4096 Sij hawm (ms.) Tag nrho: 1 Nruab nrab: (42000.00 natwm ib ntu) C: \>

Tias 's tag nrho muaj rau tus hais kom ua bcp. Koj siv tau cov lus txib ntawm hauv cov ntaub ntawv batch lossis lwm cov kev pabcuam nrog rau DOS hais kom ua kab rau automate tus ntshuam thiab export ntawm cov ntaub ntawv los ntawm koj SQL neeg rau zaub mov database.