Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Which trigger is the more efficient? |
Tue, Jul 28 2009 3:49 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Which of these two variants is going to be the more efficient in running?
DECLARE Zapper SENSITIVE CURSOR FOR ZapperSQL; DECLARE txt VARCHAR; SET txt = ''SELECT * FROM emReadStatus WHERE emReadStatus._fkEMails = ''+CAST(OLDROW._MsgNo AS VARCHAR); PREPARE ZapperSQL FROM txt; OPEN Zapper; WHILE NOT EOF(Zapper) DO DELETE FROM Zapper; END WHILE; or EXECUTE IMMEDIATE 'DELETE FROM emReadStatus WHERE emReadStatus._fkEMails = '+CAST(OLDROW._MsgNo AS VARCHAR); Roy Lambert |
Tue, Jul 28 2009 1:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Which of these two variants is going to be the more efficient in running? >> The second - it has less call overhead. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |