Emkhakheni wokuphathwa kwesizindalwazi, ikhono lokuhlola nokuqapha izinguquko noma izinguquko ezenziwe ezinkambisweni ezigciniwe ku-SQL Server isici esibalulekile sokugcina ubuqotho bedatha nokusebenza kahle. Izinqubo ezigciniwe, ezilungiselelwe ngokuyisisekelo amakhodi e-SQL alondolozwayo futhi asetshenziswa kabusha njengoba kudingeka, angashintshwa abalawuli besizindalwazi ngezizathu ezihlukahlukene njengokuthuthukisa ukusebenza, ukulungisa iziphazamisi, ukulungisa izinguquko ezidingweni zebhizinisi, njll. Uma kungalandelelwanga ngendlela efanele. , lezi zinguquko zingaholela ngokungaqondile ezinkingeni ezihlanganisa ukulahleka kwedatha noma inkohlakalo, ukungasebenzi kwesistimu, kanye nokudideka phakathi kwamathimba okuthuthukisa.
SELECT
name AS procedure_name,
create_date,
modify_date
FROM sys.procedures
Ikhodi engenhla iyisibonelo sendlela yokuthola usuku lokugcina lokuguqulwa lwazo zonke izinqubo ezigciniwe kusizindalwazi samanje. Le khodi isebenzisa ukubuka kwekhathalogi ye-sys.procedures ukuze ilande ulwazi oludingekayo.
Ukuqonda Ikhodi
Ngemva kokwenza umyalo oshiwo ngenhla we-SQL, i-SQL Server izohlinzeka ngohlu lwezinqubo ezigciniwe kanye nokudala kwazo okuhambisanayo nezinsuku zokugcina zokushintshwa.
Umphumela ungaqondwa njengokulandelayo:
- inqubo_name: Leli igama lenqubo egciniwe.
- create_date: Lokhu kumelela idethi nesikhathi inqubo egciniwe edalwe ngayo.
- modify_date: Lokhu kubonisa usuku nesikhathi inqubo egciniwe egcine ukulungiswa ngayo.
Kulesi simo, ukubuka kwekhathalogi ye-sys.procedures kuwusizo kakhulu ngoba kuqukethe umugqa owodwa wenqubo ngayinye egciniwe kudathabheyisi yamanje. Amakholomu abalulekile enhloso akhona yi-'igama', 'usuku_lokudala', kanye ne-'usuku_lokuguqula'.
Okuningi ku-sys.procedures Catalog View kanye Neminye Imisebenzi Ewusizo
Njengoba kushiwo ngaphambili, ukubuka kwekhathalogi ye-sys.procedures kudlala indima ebalulekile ekulandeleleni ukuguqulwa kwenqubo egciniwe. Akugcini nje ngokugcina imethadatha esekelwe esikhathini mayelana nezinqubo kodwa futhi kufaka phakathi ulwazi oluqondene nenqubo efana ne-ID yento yenqubo, i-ID yeskimu, incazelo yohlobo, nokuningi.
Amanye amakholomu ekubukeni kwekhathalogi ye-sys.procedures angasiza ekuqondeni okwengeziwe umongo ozungeze izinguquko ezenziwe ezinqubweni. Isibonelo, ikholomu ye-'type_desc' ikhombisa ukuthi inqubo YINKQUBO evamile yini, inqubo enwetshiwe (EXTENDED_PROCEDURE), noma uma iyingxenye yesistimu yokuphindaphinda ye-SQL Server (REPLICATION_PROCEDURE).
Ngaphezu kwalokho, i-SQL Server iphinde inikeze ukusebenza okungasetshenziswa ekulandeleleni izinguquko zezinqubo ezigciniwe njengokubuka kwekhathalogi yesistimu ye-sys.sql_modules kanye nomsebenzi owakhelwe ngaphakathi we-OBJECT_DEFINITION.
Sekukonke, kubalulekile ukusebenzisa lawa mathuluzi ngokufanele ukuze ulawule idatha egciniwe kanye nokugcina ubuqotho bezinqubo zakho ze-SQL ezilondoloziwe. Ikhono lokulandelela nokubuyekeza izinguquko lihlinzeka ngomkhondo wokucwaninga wokulungisa amaphutha, wokuthuthukisa, kanye nokugcina ukucaca nokuvumelana ezindaweni ezihlanganyelwe.
