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?
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.
trunc(number,[number of decimals])- truncates a number
----> (sqlServer2k) use CONVERT(CHAR(12), STRING)
0 emptyColumnName (oracle)
0 as emptyColumnName (sqlServer)