Click to See Complete Forum and Search --> : Very Easy SQL Question--Someone Please Help


Bill
01-05-2001, 10:21 AM
This is as simple as it gets--

I know two dashes "--" Cancels out a line

How can I cancel out a whole paragraph of code without having to delete and
copy paste over and over.

For example

if I had a paragraph I wanted to cancel out

AND f.end_dte = (SELECT MAX(f.end_dte)
from bfg_admin.db_ann_earning_hist f
where f.emp_employee_id = e.db_employee_id
and h.emp_employee_id = f.emp_employee_id
AND c.emp_employee_id = e.db_employee_id
AND e.db_employee_id = d.emp_employee_id
AND g.rel_ind_indicative_id = d.ind_indicative_id)

What could I write in the beginning and the end of the paragraph so that
SQL ignores it.

Jason Rein
01-05-2001, 10:23 AM
Put the following around the paragraph.

/*
this is a multi-line
comment in SQL.
*/

- Jason

"Bill" <Bill206a@yahoo.com> wrote:
>
>This is as simple as it gets--
>
>I know two dashes "--" Cancels out a line
>
>How can I cancel out a whole paragraph of code without having to delete
and
>copy paste over and over.
>
>For example
>
>if I had a paragraph I wanted to cancel out
>
> AND f.end_dte = (SELECT MAX(f.end_dte)
> from bfg_admin.db_ann_earning_hist f
> where f.emp_employee_id = e.db_employee_id
> and h.emp_employee_id = f.emp_employee_id
> AND c.emp_employee_id = e.db_employee_id
> AND e.db_employee_id = d.emp_employee_id
> AND g.rel_ind_indicative_id = d.ind_indicative_id)
>
>What could I write in the beginning and the end of the paragraph so that
>SQL ignores it.

suresh
01-05-2001, 12:03 PM
Beginning
/*
..
*/

"Bill" <Bill206a@yahoo.com> wrote:
>
>This is as simple as it gets--
>
>I know two dashes "--" Cancels out a line
>
>How can I cancel out a whole paragraph of code without having to delete
and
>copy paste over and over.
>
>For example
>
>if I had a paragraph I wanted to cancel out
>
> AND f.end_dte = (SELECT MAX(f.end_dte)
> from bfg_admin.db_ann_earning_hist f
> where f.emp_employee_id = e.db_employee_id
> and h.emp_employee_id = f.emp_employee_id
> AND c.emp_employee_id = e.db_employee_id
> AND e.db_employee_id = d.emp_employee_id
> AND g.rel_ind_indicative_id = d.ind_indicative_id)
>
>What could I write in the beginning and the end of the paragraph so that
>SQL ignores it.