Kutshanje, ngokumangala, ndiye ndafunda ukuba kwelinye lamasebe enkampani enkulu endisebenza kuyo, ukusungulwa kwe Iprofayili yeSQL ngeeyure zomsebenzi.
Andazi ukuba baphuma njani ukuze bahlalutye iingxaki zokusebenza ezenzeka nje kwiiyure zeshishini. Emva kwayo yonke loo nto, iimbono zentsebenzo zihlala zinganiki umfanekiso ochanekileyo, ngakumbi ukuba inkqubo enye / ezimbini / imibuzo icotha, ngaphandle kokulayisha ngokukodwa umncedisi ngokwawo. IQueer encinci ebaleka amatyeli aliqela ngeyure kwaye ibaleka imizuzwana eli-10 endaweni yesinye (kodwa iyayenza ibaluleke kakhulu umxhasi uvalo kakhulu) ngokuqinisekileyo ayizukungena kwiimbono zeDMV. Kwaye ukhethe nge-CROSS APPLY ngokwemibhalo yombuzo ngokwayo ilayisha umncedisi ngamandla kakhulu.
Nangona kunjalo, ndinomdla wokuqonda apho olu loyiko luvela khona. Kwezinye iifemu Iprofayili yeSQL - isixhobo esisebenzayo, kwezinye babesaba, njengomlilo (ixesha elithile ndandibandakanyeka ekubonisaneni kwaye ndingathelekisa). Ndiqinisekile ukuba ihambe ngolu hlobo:
Houston, sinengxaki. Isiseko siyacotha. zama ufumana
Maninzi kakhulu amakhalane apha⦠Ndidinga ntoni?
Kulungile, ndiza kuphawula zonke iibhokisi kwaye ke ndiza kuthatha isigqibo.
Yintoni eseleyo kwintloko yabasemagunyeni? Kwaqaliswa umntu Iprofayili yeSQL kwaye yonke into yangena endaweni. Kwaye ke bayayixelela omnye komnye ngomdlalo wegalufa.
Ngendlela, umzamo wokubhala phantsi ezinjalo 'sibhala yonke into' ayilandeleli ifayile, kodwa kwisiseko sedatha kumncedisi omnye - ndakhe ndangqina ityala elinjalo.
Kwaye zinjani izinto kuwe? Nceda uthathe inxaxheba kuphando
Ngabasebenzisi ababhalisiweyo kuphela abanokuthatha inxaxheba kuphando. , ndiyacela.
Ngaba ungayenza iprofayile yeSQL kwiPROD?
-
Siyinkampani encinci, yonke into ilula kuthi
-
Abaphathi bemveliso banako kunjalo
-
Abalawuli bemveliso banako, emva kokuvuma kunye nokubetha
-
ungcwele ungcwele ungcwele
4 abasebenzisi bavoti. Abasebenzisi aba-3 abakhange.
umthombo: www.habr.com