ID Edition? General MS SQL training?

I have two questions.

First is there an easy way to tell what
edition of MS SQL Server is on a machine?
I found some code that is supposed to do
this, but if I put that code into the query
analyzer, it doesn't work. (Doesn't look
like SQL query in any case.)

A more general question: Education about SQL.

I have an MS in biostats so I'm not totally
computer illiterate, but I've never programmed
anything GUI.

Thanks for any answers

Michael Young<mcl2@.vms.cis.pitt.edu> wrote in message
news:c5eton$kp4$1@.usenet01.srv.cis.pitt.edu...
> I have two questions.
> First is there an easy way to tell what
> edition of MS SQL Server is on a machine?
> I found some code that is supposed to do
> this, but if I put that code into the query
> analyzer, it doesn't work. (Doesn't look
> like SQL query in any case.)
> A more general question: Education about SQL.
> I have an MS in biostats so I'm not totally
> computer illiterate, but I've never programmed
> anything GUI.
> Thanks for any answers
> Michael Young

SELECT @.@.VERSION
SELECT SERVERPROPERTY('Edition')

The second one is only in SQL2000 only. As for education, you might want to
start with some general books on databases and the SQL language, although
Microsoft's own training material is usually pretty good. You may find some
useful information here:

http://vyaskn.tripod.com/sqlbooks.htm

Simon|||<mcl2@.vms.cis.pitt.edu> wrote in message
news:c5eton$kp4$1@.usenet01.srv.cis.pitt.edu...
> I have two questions.
> First is there an easy way to tell what
> edition of MS SQL Server is on a machine?
> I found some code that is supposed to do
> this, but if I put that code into the query
> analyzer, it doesn't work. (Doesn't look
> like SQL query in any case.)
> A more general question: Education about SQL.
> I have an MS in biostats so I'm not totally
> computer illiterate, but I've never programmed
> anything GUI.
> Thanks for any answers
> Michael Young

SELECT @.@.VERSION
SELECT SERVERPROPERTY('Edition')

The second one is only in SQL2000 only. As for education, you might want to
start with some general books on databases and the SQL language, although
Microsoft's own training material is usually pretty good. You may find some
useful information here:

http://vyaskn.tripod.com/sqlbooks.htm

Simon