SQL is an acronym for Structured Query Language. It is a commonly-used querying language across numerous transactional databases, although each database has their own syntax or "flavor" of SQL. Some are more powerful or complex than others, and all are custom tuned to whatever database they support. As an example:
MS Access = Jet SQL
MS SQL Server = Transact-SQL
Oracle = PL/SQL
and so on
I thought SQL meant structured query language?
Wouldn't that make the server just the device it runs on? ;)
isn't SQL the foundation of Microsoft Access (from waaay back) that predates the Microsoft SQL Sever product doesn't it?
SQL is an acronym for Structured Query Language. It is a commonly-used querying language across numerous transactional databases, although each database has their own syntax or "flavor" of SQL. Some are more powerful or complex than others, and all are custom tuned to whatever database they support. As an example:
MS Access = Jet SQL MS SQL Server = Transact-SQL Oracle = PL/SQL and so on