Ko te Bcp te huarahi tere ki te tiki raraunga ki roto i te paparangi
Ko te kape nui (bcp) o te Microsoft SQL Server e whakarato ana ki a koe ki te kaha ki te whakauru i te maha o nga reta tika mai i te raina whakahau. I tua atu i te mea he taputapu whai hua mo te raupapa whakahau-raupapa, he mea kaha te taputapu mo te hunga e whai ana ki te whakauru i nga raraunga ki roto i te raraunga SQL Tūmau i roto i te kōnae puranga, i tetahi atu waahana kaupapa. He maha nga huarahi ki te tiki raraunga ki roto i te paparangi raraunga, engari ko te waa te mea tere atu ina whakaturia ana ki nga tawhiti tika.
bcp Syntax
Ko te syntax matua mo te whakamahi i te bcp ko:
bcpkei hea nga take e whai ana i nga uara e whai ake nei:
- Ko te ingoa table_name te ingoa tino whaimana o te ripanga. Hei tauira, ka taea e koe te whakamahi i te inventory.dbo.fruits ki te whakauru i nga rekoata ki te ripanga hua e mau ana i te kaipupuri raraunga i te paparanga papaarangi.
- Ka whakaatuhia e te tohu te hiahia koe ki te kawemai ("i roto i te" ahunga), kaweake ranei ("i roto i te" tohutohu).
- Ko te Ingoa Kōnae te huarahi tino ki te kōnae. Hei tauira, ka taea e koe te kawemai i te kōnae C: \ fruit \ inventory.txt.
- Ko nga whiringa ka taea e koe te tautuhi i nga tawhiri mo te mahi nui. Hei tauira, ka taea e koe te tautuhi i te tau teitei o nga hapa i whakaaetia ki te whiringa -m. Ka taea hoki e koe te whakamahi i te -x hei tohu i te whakatakotoranga kōnae XML. Tirohia nga tuhinga a te Microsoft mo te rarangi katoa.
bcp Kawemai tauira
Ki te whakauru katoa, whakaarohia he ripanga kai ki roto i to paparanga papapukapukapuka me te hiahia koe ki te kawemai i nga tuhinga katoa mai i te kohinga kuputuhi kua rokirokihia ki runga i to puku ki roto ki taua papaarangi. Ka whakamahi koe i te tohutoro whakahau bcp e whai ake nei:
bcp inventory.dbo.fruits in "C: \ fruit \ inventory.txt" -c-Ka whakaputa mai i tenei putanga:
C: \> bcp inventory.dbo.fruits in "C: \ fruit \ inventory.txt" -c-Pukapuka ka timata ... 36 nga rarangi i tāruatia. Te rahi o te putea whatunga (nga tarai): 4096 Time Clock (ms.) Te tapeke: 16 Te toharite: (2250.00 rarangi mo te haurua.) C: \>Kua kitea pea e koe etahi waahanga hou e rua i runga i taua raina whakahau. Ko te kōwhiringa -c e tohu ana ko te hōputu kōnae o te kōnae kawemai he kuputuhi kua tautuhia ki te ripa ki ia tuhinga i runga i te rarangi hou. Ko te -Taatau e tohu ana me whakamahi te bcp ki te whakamotuhēhēnga Windows hei hono atu ki te pātengi raraunga.
bcp Kaweake tauira
Ka taea e koe te kaweake i nga raraunga mai i to papamahi me te whakatairanga i te ahunga o te mahi mai i "i" ki "waho." Hei tauira, ka taea e koe te maka i te ihirangi o te ripanga hua ki te kōnae kuputuhi me te whakahau e whai ake nei:
bcp inventory.dbo.fruits out "C: \ fruit \ inventory.txt" -c-Koinei te ahua o tenei e titiro ana ki te raina whakahau:
C: \> bcp inventory.dbo.puta i roto i te "C: \ fruit \ inventory.txt" -c -Tapeke tīmata ... 42 rarangi i tāruatia. Te rahi o te putea whatunga (nga tarai): 4096 Time Clock (ms.) Te tapeke: 1 Te tau toharite: (42000.00 rarangi mo te haurua.) C: \>Koinei te mea katoa ki te whakahau-a-ringa. Ka taea e koe te whakamahi i tenei tono i roto i nga kōnae puranga, i etahi atu papatono ranei me te uru ki te raupapa whakahau DOS hei whakahaere aunoa i te kawemai me te kaweake o nga raraunga mai i to papamahi SQL Server.