SQL Select

[mikecrengland]

Hello All -

Is there any difference between these two statements (the SQL being the difference):

Load

     *

;

Select

     *

From dbo.table

;

Load

     *

;

SQL

Select

     *

From dbo.table

;

Does having the SQL in the statement change how it behaves?

Thanks!

mike

[swuehl · Accepted solution]

Both work the same.

You don't need to use SQL before the SELECT.

edit: From the old help pages:

The syntax:

SQL SELECT * from tab1;

is allowed, and will in future documentation be the preferred syntax for Select (SQL), for reasons of consistency. The SQL prefix will, however, remain optional for select statements.

[mikecrengland]

Thanks!

[Anonymous]

The syntax that you used looks correct. The use of SQL is basically to issue SQL database command like calling a stored procedure or an SQL function. Also an update statement given a  correct connection mode.

Really to what you are showing, it will not make much difference, However the usage of an SQL command is more than just selecting records.

Please refer to the help file to get more info.

I hope this helps.