Me pehea te kawemai me te kaweake raraunga me te SQL Server 2012

Te whakamahi i te Ruānuku Kawemai me te Kaweake

Ka taea e te Ruānuku Kawemai Kawemai me te Kaweake Uru te kawe ki a koe ki te kawemai i nga korero ki roto i te raraunga SQL Server 2012 mai i tetahi o nga puna raraunga e whai ake nei:

• Microsoft Excel
• Microsoft Access
• Flat kōnae
• Tetahi Pātengi raraunga Tūmau SQL

Ka hangaia e te ruānuku ngā kohinga SQL Integration Ratonga (SSIS) mā roto i te atanga ataata hoahoa.

Tīmata i te Ruānuku Kawemai Kawemai me te Kaweake Uru

Tīmatahia te Ruānuku Kawemai Kawemai me te Kaweake Whirihoranga mai i te tahua Tīmata i runga i tētahi pūnaha e SQL Server 2012 kua tāutahia. I tua atu, mehemea kei te whakahaere tonu koe i te Kaiwhakahaere Whakahaere Tūmau SQL, whai i enei taahiraa hei whakarewa i te ruānuku:

1. Whakatūwheratia te Whakahaere Whakahaere Tūmau SQL .
2. Whakaratohia nga taipitopito o te tūmau e hiahia ana koe ki te whakahaere me te ingoa kaiwhakamahi me te kupuhipa tika mehemea kaore koe e whakamahi ana i te Motuhēhēnga Windows .
3. Pāwhiritia Pahono kia hono atu ki te tūmau mai SSMS.
4. Pāwhiri-matau i te ingoa o te waahi raraunga e hiahia ana koe ki te whakamahi me te whiriwhiri i te Raraunga Kawemai i te tahua Mahi .

Te kawemai i te Raraunga ki te Tūmau SQL 2012

Ka arahi te Ruānuku Kawemai Kawemai me te Kaweake Kaweake i a koe i roto i te tukanga o te kawemai i nga raraunga mai i tetahi o nga puna raraunga kei te whakauru ki te papaaaturanga SQL Server. Ko tenei tauira e haere ana i roto i te tukanga kawemai i nga korero whakapiri mai i Microsoft Excel ki te Paerewa SQL Server, me te kawe mai i te raraunga mai i tetahi tauira hoapaki a Excel ki te ripanga hou o te papaaaturanga SQL Server.

Anei:

1. Whakatūwheratia te Whakahaere Whakahaere Tūmau SQL .
2. Whakaratohia nga taipitopito o te tūmau e hiahia ana koe ki te whakahaere me te ingoa kaiwhakamahi me te kupuhipa tika mehemea kaore koe e whakamahi ana i te Motuhēhēnga Windows.
3. Pāwhiritia Pahono kia hono atu ki te tūmau mai SSMS.
4. Pāwhiri-matau i te ingoa o te waahi raraunga e hiahia ana koe ki te whakamahi me te whiriwhiri i te Raraunga Kawemai i te tahua Mahi . Pāwhiritia Next .
5. Kōwhiria Microsoft Excel hei puna raraunga (mo tenei tauira).
6. Patohia te pātene Tirotiro , kimi i te kōnae address.xls i tō rorohiko, ka pāwhiriwhera .
7. Manatokohia te rarangi tuatahi o te pouaka ingoa tīwae . Pāwhiritia Next .
8. I te Whiriwhiri i te mata Matawhenua , tīpako i te Kiritaki Taumau SQL Server hei puna raraunga.
9. Kōwhiria te ingoa o te tūmau e hiahia ana koe ki te kawemai i te raraunga mai i te pouaka taka-iho Ingoa Tūmau.
10. Manatokohia nga korero whakamotuhēhēnga me te whiriwhiri i nga kōwhiringa e hāngai ana ki te aratau motuhēhēnga o tō Tūmau SQL.
11. Kōwhiria te ingoa o te pātengi raraunga motuhake e hiahia ana koe ki te kawemai i te raraunga mai i te pouaka taka-iho Database. Pāwhiritia Next , ka panuku ano ki te whakaae i te raraunga Copy from tetahi, neke atu ranei o nga ripanga whakaaro ranei i runga i te Tautuhinga Ripanga Tautuhi ranei Mataara Uiui.

1. I roto i te pouaka taka-iho, ka tohua te ingoa o te ripanga kei roto i to papapuhirangi, tuhia ranei te ingoa o te ripanga hou e hiahia ana koe ki te waihanga. I tenei tauira, i whakamahia tenei ripanga ripanga ki te hanga i tetahi ripanga hou e kiia ana he "hoapene." Pāwhiritia Next .
2. Patohia te pātene Whakamutunga ki te peke ki mua i te mata o te whakamana.
3. I muri i te arotake i nga mahi SSIS e puta ana, pawhiria te paati Whakamutunga hei whakaoti i te kawemai.

Te kaweake i nga Raraunga mai i te SQL Server 2012

Ka arahina e te Ruānuku Kawemai Kawemai me te Kaweake Whirihoranga SQL i roto i te tukanga o te kaweake i nga raraunga mai i to papamahi Tūmau SQL ki tetahi hōputu tautoko. Ko tenei tauira e haere ana koe i roto i te tukanga o te tango i nga korero whakapiri i kawemai koe i roto i te tauira o mua me te kaweake atu ki te kōnae papa.

Anei:

1. Whakatūwheratia te Whakahaere Whakahaere Tūmau SQL .
2. Whakaratohia nga taipitopito o te tūmau e hiahia ana koe ki te whakahaere me te ingoa kaiwhakamahi me te kupuhipa tika mehemea kaore koe e whakamahi ana i te Motuhēhēnga Windows.
3. Pāwhiritia Pahono kia hono atu ki te tūmau mai SSMS.
4. Pāwhiri-matau i te ingoa o te waahi paerewa e hiahia ana koe ki te whakamahi me te tautuhi i te Kaweake Raraunga mai i te tahua Tūmahi . Pāwhiritia Next .
5. Kōwhirihia te Kiritaki Taumau SQL hei punaha raraunga.
6. Kōwhirihia te ingoa o te tūmau e hiahia ana koe ki te kaweake i te raraunga mai i te pouaka takawaenga Ingoa Tūmau .
7. Manatokohia nga korero whakamotuhēhēnga me te whiriwhiri i nga kōwhiringa e hāngai ana ki te aratau motuhēhēnga o tō Tūmau SQL.
8. Kōwhiria te ingoa o te pātengi raraunga motuhake e hiahia ana koe ki te kaweake i nga raraunga mai i te pouaka taka-iho Database . Pāwhiritia Next .
9. Kōwhiritia te Waehere Whakamuri Mai i te pouaka taka-iho.
10. Whakaratohia he ara kōnae me te ingoa ka mutu i ".txt" i te pouaka kuputuhi Ingoa Kōnae (hei tauira, "C: \ Kaiwhakamahi \ mike \ Documents contacts.txt"). Pāwhiritia Next , ka Whakaara ano ki te whakaae i te raraunga Copy from one or more tables or option option.

1. Pāwhiri Panuku kia rua atu, ka mutu ki te peke ki mua i te mata o te whakamana.
2. I muri i te arotake i nga mahi SSIS e puta ana, pawhiria te paati Whakamutunga hei whakaoti i te kawemai.