Statement optiongroup (SQL dialog)

SQL*XL
home


Specifies whether SQL*XL should take the SQL read from the worksheet as 1 statement or that each cell's contents should be regarded as a single statement.

You can e.g. use multiple cells to define a command. You may also use Excel formulae to make SQL. SQL*XL will only take the formula result.

Example:

If you have the following spreadsheet you may want to let SQL*XL treat all cells as one statement

 

A

B

C

D

1

 select * from  

2

 emp      

3

 where empno= 4  

4

        

When you have the following spreadsheet you may want to let SQL*XL teat all cells as a statement:

 

A

B

C

D

1

 select * from emp;      

2

 select * from dept;      

3

 select * from salgrade;      

4

        


See also: