Iinkqubo zeSQL Server ezigcinwe

Iinkqubo ezigcinwe Ukunikezela ngokuPhakamileyo okuPhezulu kunye neNgcaciso yeNcedo

I-Microsoft SQL Server inikezela inkqubo yokugcinwa kwenkqubo yokwenza lula inkqubo yokuphuhlisa idatha ngokuqoqa izitatimende ze-Transact-SQL kwiibhloko ezilawulwayo. Iinkqubo ezigcinwe ziyanconywa ngabaphuhlisi abaninzi be-SQL Server abafumana ukulungelelanisa kunye neenzuzo zokukhusela abazivunayo zifanelekile ukutyalomali kwangaphambili ngexesha.

Iinzuzo zokusebenzisa iinkqubo ezigcinwe

Kutheni kufuneka umthuthukisi asebenzise iinkqubo ezigcinwe?

Nazi iinkalo eziphambili zale teknoloji:

• Ukuphunyezwa kwangaphambili: I- SQL Server iqulunqa inkqubo nganye egcinwe kanye emva koko iphinde isebenzise isicwangciso sokusebenza. Oku kubangela ukuqhutyelwa kokusebenza okukhulu xa iinkqubo ezigcinwe zibizwa ngokuphindaphindiweyo.
• Umnxeba womncedisi / umncedisi wendlela: Ukuba umgca we-bandwidth uyinkxalabo kwindawo yakho, uya kuvuya ukufunda ukuba iinkqubo ezigcinwe zinganciphisa imibuzo emide ye-SQL kumgca owodwa ogqithiselwa phezu kwentambo.
• Ukuphinda kusetyenziswe ngokufanelekileyo ikhowudi kunye neprogram yokubanjwa: Iinkqubo ezigcinwe zingasetyenziswa ngabasebenzisi abaninzi kunye neenkqubo zabaxhasi. Ukuba uyisebenzise ngendlela ehleliweyo, uya kufumana umjikelo wokuphuhlisa uthatha ixesha elincinci.
• Ukuphuculwa kolawulo lwezokhuseleko: Unako ukunika abasebenzisi imvume yokuphumeza inkqubo egcinwe ngokuzimela ngaphandle kweemvume zamaphepha ephantsi.

Iinkqubo ezigcinwe zifana nemisebenzi echazwe ngumsebenzisi, kodwa kukho ukungafani okucokisekileyo.

Ulwakhiwo

Iinkqubo ezigcinwe zifana noko kwakhiwa kwezinye iilwimi.

Bayamkela idatha ngefom yeimpawu zamaritha ezichazwe ngexesha lokusebenzisa. Ezi parameters zengeniso (xa ziphunyeziwe) zisetyenziselwa ukwenziwa kweengxelo zeengxelo ezivelisa ezinye iziphumo. Esi siphumo sibuyiselwa kwindawo yokubiza ngokusebenzisa ukusetyenziswa kwerekhodi, iimpazamo zokuphuma kunye nekhowudi yokubuyisela.

Oku kungathi kunomlomo, kodwa uya kufumana ukuba iinkqubo ezigcinwe zilula kakhulu.

Umzekelo

Makhe sijonge umzekelo osebenzayo ohambelana netafile ebizwa ngokuba yi-inventory eboniswe phantsi kweli phepha. Le ngcaciso ihlaziywa ngexesha langempela, kwaye abaphathi beevenkile bahlala behlolisisa amanqanaba eemveliso ezigcinwe kwindawo yabo yokugcina kwaye zifumaneke ukuthunyelwa. Kwixesha elidlulileyo, umphathi ngamnye uza kuqhuba imibuzo efana nale:

UKUQALA UMveliso, ubungakanani
KUFUNYWA
LAPHO IWarehouse = 'FL'

Oku kwaphumela ekusebenzeni ngokungasebenzi kwiSQL Server. Ngalinye ixesha umphathi wendawo yogcino aphendula umbuzo, umncedisi wesiseko unyanzelekile ukuba abuyisele kwakhona umbuzo kunye nokuwuphumeza ukususela ekuqaleni. Kwakhona kwafuneka umphathi wendawo yokugcina indawo ukuba abe nolwazi lweSQL kunye neemvume ezifanelekileyo zokufikelela kwitafile yeenkcukacha.

Kunoko, le nkqubo ingenziwa lula ngokusebenzisa inkqubo egcinwe. Nantsi ikhowudi yeprogram ebizwa ngokuthi sp_GetInventory efumana amazinga okubala kwendawo yokugcina impahla.

DALA INKQUBO sp_GetInventory
@location varchar (10)
AS
UKUQALA UMveliso, ubungakanani
KUFUNYWA
LAPHO IWarehouse = @location

Umphathi we-Florida yokugcina impahla angakwazi ukufikelela kumazinga okubala ngokukhupha umyalelo:

UKUPHATHWA KWE-sp_GetInventory 'FL'

Umphathi wendawo yokugcina impahla yaseNew York angasebenzisa inkqubo efanayo egcinwe ukufikelela kuloo ndawo:

UKUPHATHISWA KWE-sp_GetInventory 'NY'

Kuyavunywa, lo ngumzekelo olula, kodwa iinzuzo zokukhutshwa zingabonwa apha. Umphathi wendawo yokugcina impahla akadingeki ukuba aqonde i-SQL okanye ukusebenza kwangaphakathi kwenkqubo. Ukususela kumbono wokusebenza, inkqubo egcinwe isebenza ezimangalisayo. I-SQL Server idala isicwangciso sokusebenza kanye kwaye ibuye isetyenziswe ngokufaka iiparitha ezifanelekileyo ngexesha lokusebenza.

Ngoku ukuba ufunde izibonelelo zeenkqubo ezigcinwe, phuma uze usebenzise.

Zama imizekelo embalwa uze ulinganise ukuphuculwa komsebenzi ophunyeziweyo-uya kumangaliswa!

Ithebula lokuFunda