如何响应插入数据行事件? 我用adotable控件连接远程数据库sqlserver,当指定表由其它程序追加一数据行时,我程式如何响应?用何函数可以查找某数组中和指定值相匹配的项,并返回序号? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SQL SERVER 2000 创建一个触发器。CREATE TRIGGER trigger_name ON { table | view } [ WITH ENCRYPTION ] { { { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] } [ WITH APPEND ] [ NOT FOR REPLICATION ] AS [ { IF UPDATE ( column ) [ { AND | OR } UPDATE ( column ) ] [ ...n ] | IF ( COLUMNS_UPDATED ( ) { bitwise_operator } updated_bitmask ) { comparison_operator } column_bitmask [ ...n ] } ] sql_statement [ ...n ] } } 如何利用DELPHI赚更多的钱呢 这种时间格式怎么转换? TreeView节点定位问题?谢谢赐教 SQL语句改错 急求Delphi6 Enterprise版补丁 急:如何实现用户自定义(动态调整)打印版式? 如何用Ado导出数据至Dbf表中? 一个的delphi新手的问题 delphi DBImage1显示数据库中图片超过1000行时出错stream read error 不看就浪费了!如何产生如此特效呀!!! 我用DBNavigator添加一条记录后想在提交前检查当前记录是否有数据,怎么办 关于主存数据库请教
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] }
[ WITH APPEND ]
[ NOT FOR REPLICATION ]
AS
[ { IF UPDATE ( column )
[ { AND | OR } UPDATE ( column ) ]
[ ...n ]
| IF ( COLUMNS_UPDATED ( ) { bitwise_operator } updated_bitmask )
{ comparison_operator } column_bitmask [ ...n ]
} ]
sql_statement [ ...n ]
}
}