触发器创建触发器的sql语句 创建触发器的作用

创建触发器的用作

一级、修联数据库中改关的表相1、

在tudensinft数据库o 的tsduetns创中一触建器发uaoitnest_rata要d求当向stdunet表s插入一中生记学录时引发该触器发s向cres表o插中两入行据数。ue sstduenitnfogorceta ertigger utaonsier_tdtaa on tusedntsfr inserotassten coonu toffdeclar e@sno hacr(10s)elect@sn o=stdeunno from tnsertidensierti nt ocoser(ssutentno,dcoursneo)avlues(@nos1)in,srtei no tscresos(tdunteo,nocrusen)volues(@snoa2,)seecl*tfro mscres

1

ogoinestrin o ttudenss(sttduneto,stnudnteanem)avuel(s‟2070003‟,‟刘3‟)敏go

2、 s在tduntinfeo据数的stude nt库中s创一建发器触uta doletee_adt a要求当stu向edtns中表删除一生记学录时引该触发器发向coress中删表相关数据除crea。 t trigger euatoeldte_edata o studnnestfor eletedas delcar@set_sun ohac(10r

)esectl s@u_tsnostu=dentn foro mdeetedledlte sceresowhre seorcs.estuentnod=@tsu_snosleet*from ccorsesogdelte studeents were htusentno=d‟02900101

„go

、 3s在udtenintof数库据st的uentd中创建s一触器发

2

uthttp://oapuated_dtaa求当向st要duetns中修改一学表生记时录引发该发触器 s向crose表修改相关数据中。certa erigtger atuoudatp_deat anostu denstforup atdaedsecalre@tuss_onch ra1(),0sn@ocarh1()0eseclt@st_uns=stodunetno for mdeletesdelec@tso=stundnten oromf nseriedtupade stcorsseets tduenno=ts@onwehers tuendto=@nstusn_osleec t fr*m socorsegopudte atudsensstt stede ntuo=„2007n1008w‟hee strudnteo=n2‟007101‟0go

、二现比CHE C实K束更为复约杂约的操束作拒及或回滚违反绝引完整用性约束操的作在sutdneinto数据库fs 的 crose 中创一建触发au器tcheo c_dkaa要t求当s向o rce s表中入或插修改一成记录绩时引该触发器发当csreo100时e滚数回据并输信息

3

成绩出必值在须0到00分之间1请新输重!入creta erigtegr utaoheckc_daa onts orecsnsitaed o ifnestr,udpteaasdelcae rsco@re ecidmlaselct@scoeers=ocre for imsneterdif@csroo100egbniollrbak c--滚回prnit „绩值成须必0在1到0分之间 0重请新输入!‟negdoisnerti no sctrose aluesv‟(20700011,7‟,20)

1goupdtae csreosset score 89=whre etusendtn=„o0207101‟0ndaco ruesn=4ogoseu lhzreace ttirggr tregierg_snoS f ropuate adsf ipuade(snt)obegin

4

delcae@snr_noewc ah(r0),1@sonol_dharc(01)selct@enosne_ws=nof or mniertsdeselce@stno_olds=no frmo e deletudpadet css t sen=@oso_newn weher son=@so_nldenodrcaeet ritgge rutaupdoaetdat_onasfo rudapetadeclasr e@_snosc ahr(01)@,soncha r(1)

0elecs t@ssn_osno fr=omdelteedseeltc@ns=osn froo imnerstdeupadtescor ssete sno@sn=owerh enos=s_sno

s@lect*froe scomrsegoupdae stset son=„0020170‟

8hewe rso=n‟2000101‟

7gosue LJINIupdate T Gste sal=sal

+case

5

henwT.NT Oni(eselt TC.cTONf ormT,TCwhere TTN.=TOC.NOTan(dsl+acom)>m4=000gropuby TC TN.Oha vignco nu(t*>=))2htne 30

0hwen T.TN On(ieslec tct.tn foro m,TCTwhee TrTN.=OT.TCNO and sal(c+om)>30m0 0an(das+clmm)o40gorp buy T.TNC hOvanig ocntu(*)>=)2t hen020whne T.NOT insel(ecttc.tn oform,TTwChee rTTN.O=T.TCO Nna (dal+scmm)rogp buyTCTN.Oha ing covnt(*)>=2u) ten 100hwenhT.T N in(selOct tcet.n oromfT,CTwhre T.eTNOT=.CNTOgour py TCbTNO.havnigc unot(*=1)t)eh 50ne n dU

E SHLZ

LAET RTBLE SA

DD AANTVE IHAR(C4)0alter tbaleS

ATER COLLUNMn atvi eHARC16(N)LL

ALUER TAB TELS

6

ROD CPOLMNUNA IVTE

SUE_20S107000313

cr0aetet rigegr utoachce_kadt onaS Cnsietad ofin estru,padeatsdecalre@GARE Decdmialselct e@graed=gare drfm oinerstedif

@g ade100dbein grollbck a-回滚-pirn„成t值必绩须0在100分到间之请新重输!‟

入endgouse lhzdeltee rofm cwhreecno„=4cde‟ete flom srwheers n=„阳‟董

百度搜索“就爱阅读”,专业资料,生活学习,尽在就爱阅读网92to.com,您的在线图书馆

7

8