27. Moving from Access Queries to Transact-SQL

This chapter describes Structured Query Language (SQL), the grammar of the language, and SQL Server’s dialect of ANSI-92 SQL called Transact-SQL (T-SQL). Earlier chapters have demonstrated how Access translates queries you build in its Query Design view into Access SQL statements. Access SQL is another SQL dialect that closely resembles T-SQL, but Access SQL lacks T-SQL’s support for views and its extensions for functions, stored procedures, and linked servers. Access SQL is unique in its support for VBA functions—such as CCur() and DatePart()—in queries. T-SQL has equivalents to many VBA functions, but the usage syntax differs.

SQL (usually pronounced “sequel” or “seekel,” but more properly “ess-cue-ell”) ...

Get Microsoft® Access® 2010 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.