O'Reilly logo

Microsoft® Access® 2010 In Depth by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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”) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required