I assume that you meant something like
and
SELECT *
FROM my_table
WHERE my_column = #value# AND
my_date GETDATE()
I would choose the first example for readability. I don't think that
there are any performance implications.
Nathan
On Dec 9, 2005, at 12:34 PM, ooper wrote:
Just wond
What is the difference?
LArry
On 12/9/05, ooper <[EMAIL PROTECTED]> wrote:
> Just wondering if it matters how much of the query you include within the
> CDATA element?
>
> Is one of these preferable over the other? Why?
>
> SELECT *
> FROM my_table
> WHERE my_column = #value# AND
> my_date <= G
Just wondering if it matters how much of the query you include within the CDATA element?Is one of these preferable over the other? Why?SELECT *FROM my_tableWHERE my_column = #value# ANDTIA,Brian BarnettBroadband interface (RIA) + mail box saftey = http://iBatis_for_Java_Users_List.roomity.com*Your*