By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,410 Members | 1,626 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,410 IT Pros & Developers. It's quick & easy.

Sql 7

P: n/a
Whats the difference between sql 7.0 and sql 2000?
I'm learniing sql 7.0 but was wondering if I'm ,wasting my time
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi

The differences between SQL 7 and 2000 are documented the SQL 2000 Books
online which you can download. As far as wasting your time will depend on
why you are learning it and if you need to know how it works as opposed to
SQL 2000. Learning SQL 7 will have some retained value if you move to SQL
2000 or 2005.

John

"paul" <qp*****@hotmail.com> wrote in message
news:97**************************@posting.google.c om...
Whats the difference between sql 7.0 and sql 2000?
I'm learniing sql 7.0 but was wondering if I'm ,wasting my time

Jul 20 '05 #2

P: n/a
paul (qp*****@hotmail.com) writes:
Whats the difference between sql 7.0 and sql 2000?
SQL2000 has more features, not unexpectedly. The most important ones in
terms of programmability:

o Support for XML.
o User-defined functions.
o Indexed views.

In terms of manageability, there are also a few improvements, but I'm a
little more foggy on what they are.
I'm learniing sql 7.0 but was wondering if I'm ,wasting my time


"Waste of time" would be going too far, but since SQL2000 has been
out for over four years, and SQL2005 coming out next year, only learning
SQL 7 is going to make your options more limited.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.