What is the best SQL to learn??

[Scott_goddard]

I am thinking about learning SQL. Which, will be the best and most useful to
use in the next few years??

 

[Bill Mosca, MS Access MVP]

It depends on your work environment. I seem to always end up in a Microsoft
shop so, in my case, T-SQL is what I use the most...except for when I am in
Access where Jet rules the roost.

 

[Scott_goddard]

It is actually to expand my knowleage. What is the difference between T-SQL
and jet? is there anything i can download to actually put code into ans see
the tables and quieres? Need something for my laptop.

 

[John Vinson]

It is actually to expand my knowleage. What is the difference between T-SQL
and jet? is there anything i can download to actually put code into ans see
the tables and quieres? Need something for my laptop.

Microsoft Access lets you see the SQL of queries, the content of
tables and of queries, and has a fairly user-friendly query builder.
You can toggle back and forth between the query grid and SQL view.

There are nontrivial differences between the dialects of SQL used in
JET (Access databases), SQL/Server (T-SQL), Oracle, MySQL and so on -
but they are differences in dialect and details of syntax, not
different languages. For that matter, in Access you can select an
option that queries should be SQL-compatible. It's a good learning
environment, in my opinion!

John W. Vinson[MVP]

 

[dbahooker]

you kids are a bunch of fucking retards

don't tell people to run out and learn jet-specific syntax.. learn TSQL

Jet / MDB is for losers.. Access Data Projects made them obsolete 7
years ago.


-Aaron

 

[Bill Mosca, MS Access MVP]

I haven't used it, but SQL Server Express is free. You can use Access as the
interface if you create an ADP with an SQL Server backend.

As far as the difference in syntax, the basic stuff is the same except for a
few things like the wild cards. But when you get into more complex queries
you'll need Case instead of IIf.

One thing might help...You can download the SQL server Books Online (the
help files) at:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

John Viescas was kind enough to let me know about that just this morning.

If you look under the T-SQL help you find everything you need to learn the
language.

 

[aaron.kempf]

I reccomend using SQL 2000 against Access 2000, 2002 or 2003...

Access 2007 will be compatable with SQL 2005.. but until then i'd hold
off.

Microsoft somehow thinks that it's not necessary to version things
logically.. for example when Office 2000 shipped; you had to get a
special PATCH to use SQL 2000.. and then when they finally made Access
fully compatable with SQL 2000; they decided to sell you a new version.

I think that the fat lazy drunk project managers at microsoft that made
this decision should be SHOT.

-Aaron