Kutha Kutsogolo Kwa SQL Server

Wofalitsa amagwiritsa ntchito Microsoft Excel . Bwanji osapatsa ogwiritsa ntchito chida chomwe amachidziwa kale ndikuwonjezeramo kugwirizana mu malo anu a SQL Server . Ubwino wa njira imeneyi ndi awo Excel spreadsheet nthawi zonse kufikira lero ndi deta kuchokera kumapeto kutha database. Ndizovuta kuti ogwiritsa ntchito aziyika data ku Excel koma kawirikawiri ndi chithunzi cha deta panthawi yake. Nkhaniyi ikuwonetsani momwe kulili kosavuta kukhazikitsa spreadsheet ya Excel ndi kugwirizana kwa SQL yomwe mungapereke kwa ogwiritsa ntchito.

Mu chitsanzo ichi, tizitha kugwiritsa ntchito malo osungirako zitsanzo za Adventure Works zomwe Microsoft imatumiza ndi SQL Server 2008.

Zovuta: Avereji

Nthawi Yofunika: Mphindi 10

Pano & # 39; s Momwe

1. Mudzafunika zidutswa zingapo zowonjezera kuti mukhazikitse mgwirizano wa Excel ndi SQL Server.
   1. • Dzina la SQL Server - Mu chitsanzo chathu, SQL Server ndi MTP \ SQLEXPRESS.
2. Dzina lachinsinsi - Chitsanzo chathu, tikugwiritsa ntchito chiwerengero cha AdventureWorks.
3. Tawonani kapena Onani - Tikutsatira malonda a Sales.vIndividualCustomer.
4. Tsegulani Excel ndipo pangani buku latsopano la ntchito.
5. Dinani pa tsamba la Data. Pezani "Pezani Zina Zam'manja" ndipo dinani "Kuchokera ku Zina Zina" ndipo musankhe "Kuchokera ku SQL Server". Izi zimatsegula "Wothandizira Wowonjezera Data".
6. Lembani Dzina la Seva . Mu chitsanzo ichi, dzina la seva ndi "MTP \ SQLEXPRESS". Ikani Zowonjezera Zovomerezeka kuti "Gwiritsani Ntchito Windows Authentication". Njira ina ikhonza kugwiritsidwa ntchito ngati mtsogoleri wanu wachinsinsi akupereka dzina ndi dzina lanu kwa wosuta. Dinani Zotsatira. Izi zimabweretsa "Wothandizira Dongosolo Wowonjezera".
7. Sankhani deta ("AdventureWorks" mu chitsanzo chathu) kuchokera ku "Sankhani deta yomwe ili ndi deta yomwe mukufuna". Onetsetsani kuti "Kugwirizanitsa pa tebulo lapadera" kumawunika. Pezani malingaliro ("Sales.vdividualCustomer" mu chitsanzo chathu) kuchokera pandandanda ndikusankha. Dinani Kutsirizitsa komwe kumabweretsa bokosi la dialog Data Import.

1. Fufuzani bokosi lazithunzi ndikusankha kumene mukufuna kufotokoza (lomwe liripo worksheet kapena tsamba latsopano). Dinani OK chomwe chimapanga mndandanda wa Excel ndipo imatumizira tebulo lonse mu tsamba lanu.
2. Sungani tsamba lanu lamasamba ndikutumiza kwa wosuta. Chinthu chabwino pa njirayi ndi chakuti wanu ogwiritsa ntchito ali ndi deta yamakono pamene akufunikira. Ngakhale kuti deta ikusungidwa pa spreadsheet, pali kugwirizana kwa SQL Database. Nthawi iliyonse yomwe mukufuna kutsegula tsambalo, dinani pomwepo patebulo ndikusani pa "Gome" ndiyeno "Bwerezani". Ndichoncho.

Malangizo

1. Ndikofunikira kwambiri kuti muwonetsetse kuti wogwiritsa ntchitoyo akukonzekera bwino mu SQL Server. Izi ndizo zimayambitsa vuto nthawi zambiri pogwiritsa ntchito njirayi.
2. Yang'anirani chiwerengero cha zolemba zomwe ziri patebulo kapena muwone kuti mukugwirizanako. Ngati tebulo ili ndi zolemba milioni, mungafune kufotokoza izi. Chinthu chotsiriza chimene mukufuna kuchita ndi kupachika SQL Server.
3. Pa bokosi la Mauthenga a Ma Connection, pali njira yotchedwa "Bwezerani deta pamene mutsegula fayilo". Taganizirani kufufuza njirayi. Ngati njirayi ikufufuzidwa, wogwiritsa ntchito nthawi zonse adzakhala ndi deta yatsopano pamene atsegula pepala la Excel.
4. Ganizirani kugwiritsa ntchito matebulo a Pivot kuti mumvetse mwachidule deta.

Zimene Mukufunikira

• Microsoft Excel 2007
• Dongosolo la SQL Server kuphatikizapo seva, deta ndi tebulo kapena mawonedwe