Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ex
Posting Yak Master
166 Posts |
 Posted - 2004-12-16 : 19:44:36
|
| hello all.just got a little query if anyone knows interbasei have a interbase trigger that does thisCREATE TRIGGER ADJUSTDIMONDEFINEUPDATE FOR testtableACTIVE AFTER UPDATE POSITION 0AS BEGIN IF (NEW.id= 0 AND NEW.id2= 0) THEN BEGIN//process ENDENDjust wondering how this compaires to inserted and deleted tableswhen there is a multi row update?what value would be placed in the .new value? if more than one table is updated ? want to want to do is something likeif exists(select * from inserted where id = 0 AND id2 = 0)BEGINENDwould that be the same? as the interbase one |
|
|
|
|
|
interbase vs sql server