大佬教程收集整理的这篇文章主要介绍了创建触发器及函数,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
1、MysqL创建触发器
sql = "CREATE trigGER `delkm` AFTER deletE ON `td_kmdm` FOR EACH ROW begin "
+ " delete from t_pyqx where t_pyqx.kmdm=old.kmdm;"
+ " delete from td_klkmksb where td_klkmksb.kmdm=old.kmdm;"
+ " delete from td_ycdm where td_ycdm.kmdm=old.kmdm;"
+ " delete from t_jmxx where t_jmxx.kmdm=old.kmdm;"
+ " delete from td_jxxxb where td_jxxxb.kmdm=old.kmdm;"
+ " delete from t_stdfd where t_stdfd.kmdm=old.kmdm;"
+ " delete from t_qydyb where t_qydyb.kmdm=old.kmdm;"
+ " delete from t_xzdmb where t_xzdmb.kmdm=old.kmdm;"
+ " delete from t_yhtemp where t_yhtemp.kmdm=old.kmdm;"
+ " delete from td_qxzdm where td_qxzdm.kmdm=old.kmdm;"
+ " end;";s
2、MysqL创建函数
sql="create function subString_index(Str varchar(8000),strsep varchar(10),AppPos int) " +
"returns int " +
"begin" +
" declare i int;" +
" declare ii int;" +
" set Str=rtrim(ltrim(Str));" +
" set i=1;" +
" SELEct charindex(strsep,Str) into ii;" +
" if i=AppPos then " +
" return (ii);" +
" else" +
" test:while AppPos>i do " +
" begin" +
" if charindex(strsep,right(Str,len(Str)-ii))<>0 then " +
" SELEct charindex(strsep,len(Str)-ii))+ii into ii;" +
" else" +
" set ii=0;" +
" set i=i+1;" +
" end if;" +
" end;" +
" end while test;" +
" end if;" +
" return (ii );" +
" end";
3、sqlserver创建触发器
sql = "CREATE trigGER delks ON td_ksdm for deletE as "
+ " delete t_pyqx from deleted a,t_pyqx b where a.ksdm=b.ksdm ;"
+ " delete td_klkmksb from deleted a,td_klkmksb where td_klkmksb.ksdm=a.ksdm;"
+ " delete td_ycdm from deleted a,td_ycdm where td_ycdm.ksdm=a.ksdm;"
+ " delete t_jmxx from deleted a,t_jmxx where t_jmxx.ksdm=a.ksdm;"
+ " delete td_jxxxb from deleted a,td_jxxxb where td_jxxxb.ksdm=a.ksdm;"
+ " delete t_stdfd from deleted a,t_stdfd where t_stdfd.ksdm=a.ksdm;"
+ " delete t_qydyb from deleted a,t_qydyb where t_qydyb.ksdm=a.ksdm;"
+ " delete t_xzdmb from deleted a,t_xzdmb where t_xzdmb.ksdm=a.ksdm;"
+ " delete t_yhtemp from deleted a,t_yhtemp where t_yhtemp.ksdm=a.ksdm;"
+ " delete td_qxzdm from deleted a,td_qxzdm where td_qxzdm.ksdm=a.ksdm;";
4、sqlserver创建函数
sql="create function [dbo].[subString_index](@Str varchar(8000),@strsep varchar(10),@AppPos int) " + "returns int " + "begin" + " declare @i int" + " declare @ii int" + " set @Str=rtrim(ltrim(@Str))" + " set @i=1" + " SELEct @ii=charindex(@strsep,@Str)" + " if @i=@AppPos" + " return @ii" + " else" + " while @AppPos>@i" + " begin" + " if charindex(@strsep,right(@Str,len(@Str)-@ii))<>0" + " SELEct @ii=charindex(@strsep,len(@Str)-@ii))+@ii" + " else" + " set @ii=0" + " set @i=@i+1" + " end" + " return @ii " + "end";
以上是大佬教程为你收集整理的创建触发器及函数全部内容,希望文章能够帮你解决创建触发器及函数所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。