Izinqubo ezigcinwe ze-SQL Server

Izinqubo ezigciniwe Zinikezela Izinzuzo Eziphezulu Nezokuphepha

I-Microsoft SQL Server inikeza indlela yokulondolozwa kwenqubo yokwenza lula inqubo yokuthuthukiswa kwedatha ngokuqoqa izitatimende ze-Transact-SQL emabhuloki alawulwayo. Izinqubo ezigcinwe ziyakwazisa abathuthukisi abaningi be-SQL Server abathola ukuthi izinzuzo zokuphepha kanye nokuvikeleka abazivuna zifanelekile ukutshalwa kwezimali kwangaphambili ngesikhathi.

Izinzuzo Zokusebenzisa Izinqubo Ezigcinwe

Kungani umthuthukisi kufanele asebenzise izinqubo ezigcinwe?

Nazi izinzuzo eziyinhloko zalesi buchwepheshe:

• Ukukhishwa kwangaphambili: I- SQL Server iqoqa inqubo ngayinye egcinwe bese iphinda isebenzise uhlelo lokubulawa. Lokhu kuholela ekuthuthukiseni ukusebenza okukhulu lapho izinqubo ezigcinwe zibizwa ngokuphindaphindiwe.
• Ithrafikhi yekhasimende / ye-server eyancishisiwe: Uma umkhawulokudonsa wenethiwekhi ukukhathazeka kwimvelo yakho, uzokujabulela ukufunda ukuthi izinqubo ezigcinwe zinganciphisa imibuzo ende ye-SQL kumzila owodwa odluliselwa phezu kwentambo.
• Ukusetshenziselwa kabusha kwekhodi nokuhlelwa kokuhlelwa okusebenzayo: Izinqubo ezigcinwe zingasetshenziswa ngabasebenzisi abaningi nezinhlelo zamaklayenti. Uma uwasebenzisa ngendlela ehleliwe, uzothola umjikelezo wokuthuthuka uthatha isikhathi esincane.
• Ukulawulwa kokulawulwa kokuphepha: Unganika abasebenzisi imvume yokwenza inqubo egcinwe ngaphandle kwezimvume zethebula ezansi.

Izinqubo ezigcinwe zifana nemisebenzi echazwe ngumsebenzisi, kodwa kukhona ukungafani okucashile.

Isakhiwo

Izinqubo ezigcinwe zifana nezakhi ezitholakala kwezinye izilimi zokuhlela.

Bamukela idatha ngesimo semingcele yokufakwayo eshiwo ngesikhathi sokukhipha. Lezi zimingalo zokufaka (uma zisetshenziswa) zisetshenziselwa ukwenziwa kochungechunge lwezitatimende eziveza umphumela othile. Le miphumela ibuyiselwa kwimvelo yokubiza ngokusebenzisa ukusetshenziswa kwamarekhodi, imizila yokukhishwa kanye nekhodi yokubuya.

Lokhu kungase kuzwakale njengomlomo, kodwa uzothola ukuthi izinqubo ezigcinwe ziyizinto ezilula kakhulu.

Isibonelo

Ake sibone isibonelo esisebenzayo esihlobene netafula elibizwa ngokuthi i-inventory ekhonjiswe ngezansi kuleli khasi. Lolu lwazi lubuyekezwa ngesikhathi sangempela, futhi abaphathi bezinqolobane bahlale behlola amazinga wemikhiqizo egcinwe esitolo sabo futhi atholakale ukuthunyelwa. Esikhathini esidlule, imenenja ngayinye yayizophendula imibuzo efana nalokhu okulandelayo:

Khetha UMkhiqizo, Ukulingana
FROM FROM Inventory
LAPHO Indawo yokugcina = 'FL'

Lokhu kuholele ekusebenzeni okungasebenzi emsebenzini we-SQL Server. Ngaso sonke isikhathi lapho umphathi wendawo yokugcina impahla ebulala lo mbuzo, iseva yedatha yaphoqelelwa ukuba ivuselele kabusha umbuzo futhi iyenze kusukela ekuqaleni. Kwakudingeka futhi ukuthi umphathi wendawo yokugcina ulwazi abe nolwazi lwe-SQL kanye nezimvume ezifanele ukufinyelela ulwazi lwetafula.

Esikhundleni salokho, inqubo ingenziwa lula ngokusebenzisa inqubo egcinwe. Nansi ikhodi yenqubo ebizwa ngokuthi sp_GetInventory ethola amazinga okusungula igaraji elinikeziwe.

DALA INDLELA sp_GetInventory
@location varchar (10)
AS
Khetha UMkhiqizo, Ukulingana
FROM FROM Inventory
LAPHO Indawo Yokugcina = @location

Umphathi wezokugcina impahla waseFlorida angakwazi ukufinyelela amazinga okusungula ngokukhipha umyalo:

I-EXECUTE sp_GetInventory 'FL'

Umphathi wendawo yokugcina impahla yaseNew York angasebenzisa inqubo efanayo egcinwe ukuze afinyelele isamba sendawo:

I-EXECUTE sp_GetInventory 'NY'

Kuyavunywa, lesi yisibonelo esilula, kodwa izinzuzo zokukhishwa zingabonakala lapha. Umphathi wendawo yokugcina impahla akudingeki aqonde i-SQL noma ukusebenza kwangaphakathi kwenqubo. Kusukela ekuboneni kokusebenza, inqubo egcinwe isebenza izimanga. I-SQL Server idala uhlelo lokukhipha kanye bese luyisebenzisa kabusha ngokufaka imingcele efanele ngesikhathi sokukhipha.

Manje ukuthi ufunde izinzuzo zezinqubo ezigcinwe, phuma lapho futhi uwasebenzise.

Zama izibonelo ezimbalwa futhi ulinganise izithuthukisi zokusebenza ezitholakalayo-uzomangala!

Ithebula lokufaka