Exploring SQL Basics

You learned that SQL is the standard language for database manipulation. Unlike Visual Basic, which is controlled by Microsoft, SQL is governed by official standard organizations. SQL is used in the vast majority of database management programs. As with any standard, vendors choose to which degree they follow the standard in their implementation. Each vendor also typically adds non-standard extensions to their implementation. In SQL Server, the SQL implementation is called Transact-SQL. Entire books can (and have been) written about either Transact-SQL or standard SQL, so you will merely scratch the surface of SQL's capabilities in this chapter.

The SQL language is not case sensitive. Its keywords can be written in uppercase, ...

Get Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.