从SQL触发器获取查询
问题描述：
嗨
有谁知道我如何获得触发触发器的陈述.说我将触发器放在桌子上.
插入，更新，删除后
并且一旦插入了新行，我就可以提取为执行此操作而被触发的insert语句.
任何帮助都很好
请不要在谷歌上快速搜索答案我已经完成了谷歌搜索".
Hi
Does anyone know how I can get the statment that fired the trigger. say i place a trigger on a table.
AFTER INSERT, UPDATE, DELETE
And once a new row is inserted so I can extract the insert statement that was fired in order to do this.
Any help would be great
Please no quickly googled answers "I already did the googling"
答
使用SQL Server事件探查器跟踪已执行的语句.可通过Microsoft SQL Server 2008访问该语句- >性能工具-> SQL Server Profiler
Use SQL Server Profiler to track the statements that are executed.It is accessed through Microsoft SQL Server 2008 -> Performance Tools -> SQL Server Profiler