SQL Server Yakachengetedzwa Maitiro

Nzira Dzakachengetedzwa Ratidza Kubudirira Kwakawanda nekuchengeteka Mazano

Microsoft SQL Server inopa nzira yekuchengetedzwa inochengeterwa nzira yekuvandudza dhidhiyo nekugadzira zvinyorwa zveTransact-SQL mumigodhi yekugadzirisa. Nzira dzakachengetwa dzinofanirwa nevakawanda veSQL Server vadzivisi vanoona kubudirira uye kuchengeteka kwekubatsira kwavanokohwa zvinokosha zvakakosha kwekutsvaga munguva.

Kubatsira Kushandisa Nzira Dzakachengetedzwa

Sei chikwata chekushandura chichifanira kushandisa nzira dzakachengetedzwa?

Heano maikirwo anokosha ehuyukoroji:

• Precompiled execution: SQL Server inogadzira nzira imwe neimwe yakachengetwa kamwe chete uye inoshandisazve chirongwa chekuuraya. Izvi zvinoguma nekuwedzera kwekusimudzira kushanda apo nzira dzakachengetedzwa dzinodanwa kazhinji.
• Yakaderedza mutengi / seva rhuta: Kana network bandwidth ine hanya munharaunda yako, uchafara kuziva kuti nzira dzakachengetedzwa dzinogona kuderedza nguva refu SQL mibvunzo kune rimwechete rinotambanudzirwa pamusoro petambo.
• Kubudirira zvakare kwekodhi uye mapurogiramu akasiyana: Maitiro akachengetedzwa anogona kushandiswa nevashandisi vakawanda uye mapurogiramu maklayiti. Kana iwe uchivashandisa nenzira yakarongwa, uchawana hutungamiri hunoita nguva shoma.
• Kuvandudza kuchengetedzwa kwekuchengetedza: Unogona kupa vashandi mvumo yekuita nzira yakachengetedzwa pasina kuzvimiririra kwepafura mvumo.

Nzira dzakachengetwa dzakafanana nemabasa anotsanangurwa, asi pane zvakasiyana-siyana.

Maitiro

Nzira dzakachengetwa dzakafanana neyakagadzirwa mune dzimwe shanduro mitauro.

Vanogamuchira dambudziko nenzira yezvipimo zvinowanikwa panguva inoshandiswa. Izvi zviyero zvekupinza (kana zvichishandiswa) zvinoshandiswa pakuitwa kwezvikamu zvemashoko zvinogadzira zvimwe zvinoguma. Ichi chigumisiro chinodzorerwa kumamiriro ekudanwa kuburikidza nekushandiswa kwerekodhesi, zvinyorwa zvinowanikwa uye nhamba yekudzorera.

Izvozvo zvingaita sezvinoreva muromo, asi iwe uchaona kuti maitiro akachengetwa ari chaizvo nyore.

Muenzaniso

Ngatitarisei muenzaniso unoshanda wakabatana neetafura inonzi mazita akaratidzwa pasi peji rino. Aya mashoko anovandudzwa munguva chaiyo, uye vatariri vekuchengetedza vanogara vachitarisa mazinga emiti yakachengetwa pane yavo yekuchengetedza uye inowanika kutumira. Munguva yapfuura, maneja mumwe nomumwe aizobvunza mibvunzo yakafanana neyiyi inotevera:

Sarudza Mutengo, Wakawanda
FROM Inventory
WHERE Warehouse = 'FL'

Izvi zvakaguma nekushanda zvisina kukodzera paSQL Server. Nguva imwe neimwe mutariri wepurisa akauraya mubvunzo, sevhavha yepa database yakamanikidzwa kudzokorora mubvunzo uye kuitora kubva pakutanga. Izvo zvaidawo kuti mutariri wekuchengetedza zvinhu ave nezivo yeSQL uye mvumo yakakodzera yekuwana tafura yeruzivo.

Pane kudaro, iyo nzira inogona kushandiswa kuburikidza nokushandiswa kwekuchengetedzwa kwetsika. Heino mhete yekamberi inonzi sp_GetInventory iyo inotora mazinga ekugadzirisa kwepaimba yekuchengetwa.

DZENGA ZVINANGWA sp_GetInventory
@location varchar (10)
AS
Sarudza Mutengo, Wakawanda
FROM Inventory
WHERE Warehouse = @location

Mutungamiri wepaFlorida rekuchengetedza mari anogona kukwanisa kusvika pakugadzirisa maitiro nekupa mutemo:

EXECUTE sp_GetInventory 'FL'

Mutariri wekuchengetedza weNew York angashandisa nzira yakafanana yakachengetwa kuti awane nzvimbo iyo nzvimbo yacho:

EXECUTE sp_GetInventory 'NY'

Ichokwadi, ichi chienzaniso chakareruka, asi zvibatsiro zvekuregererwa zvinogona kuonekwa pano. Mutariri wezvokuchengetedza mari haafaniri kunzwisisa SQL kana kushandiswa kwemukati kwekuita. Kubva pakuona maitiro, nzira yakachengetwa inoshamisa zvishamiso. SQL Server inogadzira chirongwa chekuita kamwechete uye ichichidzorera zvakare kuburikidza nekupinza mumiganhu yakakodzera panguva yekuita.

Iye zvino zvawakadzidza kubatsirwa kwezvakachengetedzwa, enda kunze uye uzvishandise.

Edza mienzaniso mishomanana uye ona nheyo dzekugadzirisa dzinobudirira-iwe uchashamisika!

Inventory Table