Queries

[DLG_1]

what are some differences between a MS Access 97 query and a SQLServer 2k query? syntax?

are there any free tools (color coding, etc.) that are great for complex sql??

great site for information?

dlg

[DLG_1]

a few things:
first, it wasn't written in MS Access SQL specific language, the query (over 750 lines of code) was written in Oracle.

diff.
trunc(number,[number of decimals])- truncates a number
----> (sqlServer2k) use CONVERT(CHAR(12), STRING)

0 emptyColumnName (oracle)
0 as emptyColumnName (sqlServer)


dlg