Difference between 'SQL Code', 'MySQL' & 'SQL Server 2000'

[mel_flynn]

As I stated earlier, I'm looking for a book on SQL Code. What I've found are books on 'SQL Code', 'MySQL' & 'SQL Server 2000'. So what is the difference?

[kleinma]

well basically you will just find some syntax differences in the language... for the most part the logic is the same and most keywords are the same... but just like you will see in the SQL server engine versus the MS Jet engine with dates where

#03/04/2003# is the date format for access

'03/04/2003' is the date format for SQL Server

so a book on SQL code will probably cover the aspects that are the same for SQL in general.. or it might even get into the specific differences between certain engines... i have a book "mastering database programming with VB6" from SYBEX and it talks about JET and SQL Server and the differences...but not oracle at all...

get the idea???

[Sundance Kid V2]

I got a book on SQL.. it talks about the Big 8 (Oracle,MS SQL2k,MySQL etc). It just about the preformance of Queries etc. But its not good in the sense for learning SQL..

I read about a book : The Guru guide to T-SQL.... now that look nice, but is 2 years old..

[Frans C]

T-SQL is short for Transact SQL, which is the SQL server dialect. Just like P-SQL is oracles dialect.
Most databases are ANSI-92 SQL complient (which is the standard) and the extra features are put in their own SQL dialect.

So if you want to learn SQL that will work in most databases, try to find a book that covers ANSI 92 SQL.
The SQL for creating databases, tables, indexes etc. is mostly database specific (oracle uses tablespaces, SQL Server uses File groups etc.), so if you want to learn this, you will need to learn the specific dialect for the database you want to use (T-SQL, P-SQL etc.). Mostly these are explained pretty thoroughly in the databases documentation, so you probably don't need to buy a book for that.
eg SQL Server comes with the Books Online. It contains all you need to know.