Stored Procedure / Trigger - 谢谢 - Database版

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - Stored Procedure / Trigger - 谢谢

相关主题
● 如何让SQL 2005 CLR Trigger返回结果给Stored Procedure用?	● how can i execute pl/sql (or stored procedure) in java??
● 求建议，要面没有project经验，但自学了的东西 (转载)	● [转载] intensive I/O and odbc problem
● 德州招SQL Developer	● stored procedure help Please.....
● 求教：Oracle trigger 中生成的数据如何送到stored procedure中？	● stored procedure 菜鸟一问, PLEASE HELP,在线等
● SQL debug step into a store procedure from another one (转载)	● 怎末优化一个stored procedure ?
● In MySQL, 如何在procedure里create trigger？谢谢了？	● 请推荐关于Stored Procedure的书
● Stored Procedure?	● Can I use array in SQL stored procedure?
● 如何分析Stored Procedure运行时间过长？	● Help: stored procedure in oracle

相关话题的讨论汇总
话题: stored话题: trigger话题: procedure话题: accounting话题: accuracy

进入Database版参与讨论

(共1页)

z****a
发帖数: 3

需要在数据库里写些Stored Procedure / Trigger 来
verify数据的Accuracy和completeness ，数据和Accounting/Finance有关。应该考虑哪
些情况呢?比如说，保证INSERT时不会有duplicate record产生。除此之外，还应考虑哪
些简单和复杂的senarior呢？谢谢！

D****N
发帖数: 430

check this one out..
http://www.sql-server-performance.com/trigger_tuning.asp
it says using triggers to maintain referential integrity is expensive...

【在 z****a 的大作中提到】

: 需要在数据库里写些Stored Procedure / Trigger 来
: verify数据的Accuracy和completeness ，数据和Accounting/Finance有关。应该考虑哪
: 些情况呢?比如说，保证INSERT时不会有duplicate record产生。除此之外，还应考虑哪
: 些简单和复杂的senarior呢？谢谢！

(共1页)

进入Database版参与讨论

相关主题
● Help: stored procedure in oracle	● SQL debug step into a store procedure from another one (转载)
● 问一个crystal report的问题	● In MySQL, 如何在procedure里create trigger？谢谢了？
● Why does this Stored procedure fail ?	● Stored Procedure?
● 请教：how to call a COM object in a stored procedure?	● 如何分析Stored Procedure运行时间过长？
● 如何让SQL 2005 CLR Trigger返回结果给Stored Procedure用?	● how can i execute pl/sql (or stored procedure) in java??
● 求建议，要面没有project经验，但自学了的东西 (转载)	● [转载] intensive I/O and odbc problem
● 德州招SQL Developer	● stored procedure help Please.....
● 求教：Oracle trigger 中生成的数据如何送到stored procedure中？	● stored procedure 菜鸟一问, PLEASE HELP,在线等

相关话题的讨论汇总
话题: stored话题: trigger话题: procedure话题: accounting话题: accuracy

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

boards

未名新帖统计// 7月16日

历史上的今天