Viewing 3 posts - 1 through 3 (of 3 total)
The answer is in your code....
The first is faster because the code is direct, absolute...
The second requires much more intrepretation, compiling plus use of quotes is creating literals of...
July 13, 2004 at 1:45 am
#514341
Andy,
Of course one of the best answer would be to add print statements, but in reality no better of an answer than checking your test data or verifying your program...
July 13, 2004 at 1:14 am
#514339
IF you are wanting to assign a variable,
use SET. It is 3x more efficient even on multiple variable assignment.
SELECT is a SQL command performing other task not necessary...
February 24, 2003 at 8:43 am
#449581