hi I have a question about trigger
If i create a trigger on table a
now in trigger I check for if inserted fields 'Name' is 'All' then
loop through Names table and insert all names in the A table ' in this insertion no name contains 'All'
will it work or will it go in infinite loop or
insert statement will call the trigger again and loop will never get the control for previous state 'in other words loop will never
executed after first
View Complete Post