创建触发器及函数
来源:互联网 发布:淘宝开店的押金怎么退 编辑:程序博客网 时间:2024/05/16 01:29
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,right(Str,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,right(@Str,len(@Str)-@ii))+@ii" +
" else" +
" set @ii=0" +
" set @i=@i+1" +
" end" +
" return @ii " +
"end";
- 创建触发器及函数
- 存储过程,函数及触发器
- 存储过程,触发器及函数
- 基于quartz触发器管理及动态创建触发器
- MySQL基于实例sales创建自定义函数、视图、存储过程、触发器及查询结果创建新表
- 触发器的创建及使用(sqlserver 2005)
- 触发器的创建及使用(sqlserver 2005)
- 【MySQL】MySQL创建触发器及相关资料
- Oracle创建触发器详解及例子
- MYSQL创建存储过程,函数,触发器,索引
- postgresql 创建表,创建存储过程 创建触发器 创建触发器函数
- 存储过程、存储函数及触发器简介
- 创建触发器
- 创建触发器
- 创建触发器
- 创建触发器
- 创建触发器
- 创建触发器
- 目标与执行[拖欠一篇]
- [转]读书笔记《c语言深度解剖》(1)
- MFC 加载 光标
- 教你建一个别人既[无法打开]也[无法删除]的文件夹
- 金额转换,阿拉伯数字转换成中国传统形式。
- 创建触发器及函数
- C# Tip -- Component 子类标准化事件实现机制
- Android的反射机制Reflection
- IT人士应当知道的10个行业小内幕
- 如何解决"应用程序无法启动,因为应用程序的并行配置不正确"问题
- android应用程序调试
- 设计模式----单例模式
- Linux 下博客离线发布客户端 Blogilo,支持CSDN
- symbian下的数据库DBMS错误码(转)