Whakamua Whakamutunga ki te Tūmau SQL

Ko te kaiwhakamahi matatau kei te mahi whakamarie i roto i Microsoft Excel . He aha e kore ai e whakarato ki o kaiwhakamahi me te taputapu kua mohiohia e ratou, ka honoa atu ki a raatau he hononga ki to taiao Tūmau SQL . Ko te painga o tenei huarahi ko to raatau pukamahi Excel kei te waa tonu me te raraunga o te raraunga whakamutunga. Ko te tikanga mo nga kaiwhakamahi ki te tuku raraunga ki Excel engari ko te nuinga o te waahanga o te raraunga i te wa i te waa. Ka whakaatuhia e tenei tuhinga ki a koe te ahua o te mahorahora i te ripanga ripanga a Excel me te hononga ki te SQL ka taea e koe te whakarato ki o kaiwhakamahi.

I roto i tenei tauira, ka whakamahi tatou i te paerewa tauira tauira Adventure Works e nga kaipuke Microsoft me SQL Server 2008.

Te uaua: Te toharite

Te wa e hiahiatia ana: 10 meneti

Here Me pehea

1. Ka hiahia koe ki etahi korero iti hei whakarite i te hononga Excel ki te Hononga Tūmau SQL.
   1. • Ingoa Tūmau SQL - I to tatou tauira, ko te Kaiwhakamahi SQL ko MTP \ SQLEXPRESS.
2. Ingoa Raraunga - To tatou tauira, kei te whakamahi tatou i te pātengi raraunga AdventureWorks.
3. Ripanga ranei Tiro - Kei te haere tatou i muri i te tirohanga Sales.vIndividualCustomer.
4. Whakatūwheratia te Excel me te waihanga i tētahi pukamahi hou.
5. Pāwhiritia te Raraunga Raraunga. Rapua te kohinga "Tangohia te Raraunga Tuku" me te panui i "Mai i Nga Raataki Motuhake" ka whiriwhiri "Mai i te SQL Server". Ka tuwhera te "Ruānuku Hononga Raraunga".
6. Whakakihia te Ingoa Tūmau . I tenei tauira, ko te ingoa o te ingoa "MTP \ SQLEXPRESS". Tautuhia nga Tohu Whakauru ki te "Whakamahia te Motuhēhēnga Windows". Ka whakamahia te atu waahanga mehemea i whakaratohia e te kaiwhakahaere o te paatai ​​he ingoa kaiwhakamahi me tetahi kupuhipa mo to kaiwhakamahi. Pāwhiritia Next. Ko tenei ka ara ake te "Ruānuku Hononga Raraunga".
7. Tīpakohia te pātengi raraunga ("AdventureWorks" i roto i to tatou tauira) mai i te "Tīpakohia te pātengi raraunga kei roto i te raraunga e hiahia ana koe" tohua te pouaka. Me whakarite "Ka hono ki tetahi tepu motuhake" ka tirohia. Kimihia te tirohanga ("Sales.vIndividualCustomer" i roto i to tatou tauira) mai i te rarangi me te whiriwhiri i te reira. Pāwhiritia te Mutu e whakaputa mai ana i te pouaka korero Kawemai Kawemai.

1. Tirohia te pouaka pouaka Ripanga me te whiriwhiri i hea e hiahia ana koe ki te tuku i te raraunga (waaahi mahi me te tuhinga mahi hou). Pāwhiritia OK e waihanga ana i te raupapa Excel me te kawemai i te ripanga katoa ki roto i to ripanga.
2. Tiakihia te ripanga me te tuku ki te kaiwhakamahi. Ko te mea pai mo tenei tikanga ko te whai mana o to kaiwhakamahi ki nga raraunga o naianei ina hiahia ana koe. Ahakoa e ora ana te raraunga ki te ripanga, he hononga ki te Database Database. I nga wa katoa e hiahia ana koe ki te whakahou i te ripanga, ka tika te panui i tetahi wahi i te tepu ka pa ki te "Ripanga" me te "Whakahou". Koinei.

Tips

1. He mea tino nui kia mohio koe he pai te tautuhinga o te kaiwhakamahi i roto i te SQL Server. Koinei te mea e whai take ana i te nuinga o nga take e whakamahi ana i tenei tikanga.
2. Tirohia te maha o nga rekoata i roto i te ripanga, te tiro ranei kei te hono koe ki. Mena kei te ripanga he miriona tuhinga, ka hiahia pea koe ki te tautuhi i tenei. Ko te mea whakamutunga e hiahia ana koe ki te mahi ka whakairihia te Tūmau SQL.
3. I te pouaka korero Whakarite Hononga, kei reira he kōwhiringa i huaina "Whakahou raraunga ka whakatuwheratia te kōnae". Whakaarohia te tirotiro i tenei kōwhiringa. A, no te tirohia tenei kōwhiringa, ka whai tonu te kaiwhakamahi i te huinga raraunga hou ka whakatuwherahia te ripanga ripanga o Excel.
4. Whakaarohia te whakamahi i nga Ripanga Pivot hei whakaemi i nga raraunga.

He aha e hiahia ana koe

• Microsoft Excel 2007
• He raraunga SQL Tūmau tae atu ki te tūmau, te pātengi raraunga me te ripanga, te tirohanga ranei