View Review Details


Book:   SQL In A Nutshell
Subject:   SQL in a Nutshell Review
Date:   2001-07-18 10:22:24
From:   Brian Lalonde
Rating:  StarStarStarStarStar


This is a decent first edition, but I would like to see some additional info about desktop databases. Occasionally, DBAs (for whatever reason) get forced into using FoxPro, dBase, Access, FileMaker, etc.


A comprehensive reference that contrasts the syntax and datatypes of those databases with more familiar ("real") database systems could dramatically cut down on trial-and-error time. Knowing, for example, that Access uses "autonumber" fields, rather than SQL Server's "identity" would be useful to someone who does not have access to Access, but is creating their schema through an Access ODBC driver.


Even a simple appendix showing what ODBC drivers (or levels) support would help seasoned SQL programmers leverage their experience into other markets.



See larger cover
Browse within this book