The following is certainly not exhaustive, but they are differences that cause most of the confusion when first trying to use T-SQL. I'll start by just listing the basics, but I'll spend some time over the next few months expanding on them. The problem is it must be in the syntax used by the Server database. A Pass-Through query passes the SQL Statement on directly to the Server database (ie: SQL Server, Oracle, etc.).
This is especially true when trying to convert an Access query to a Pass-Through query.
There are many times when an experienced Access user will know exactly how to do what they want in Access, but cannot figure out how to do the same thing in T-SQL. And yet for all that, the differences can be frustrating. They share much the same structure, syntax, and many functions. Access SQL and SQL Server's T-SQL have more in common than differences.
0 kommentar(er)
