Friday, March 23, 2012

i want to test database trigers

I want to test test database Trigers

Quote:

Originally Posted by Praveenkumarawasthi

I want to test test database Trigers


Then do it. :-)
But seriously: what can we do for you?|||

Quote:

Originally Posted by Praveenkumarawasthi

I want to test test database Trigers


relax, he's kidding :)

if you want to test if it's firing, you can do a command inside the trigger that will allow you to see if it's running. do a simple select, make sure that your select will return just 1 value, say select @.var. i also tried doing a select ... into newtable from inserted and it worked. just make sure the newtable is not existing before the trigger runs.

you can place this in different parts of your trigger. do a select 'over here' so that you can see which part is giving you problem. it's an old way of doing a "debug" for language with no debug mode.

No comments:

Post a Comment