SQL:1999 question

[JohnWise]

Would one be able to read a text on this and get a decent understanding of 2000?
Thanks.

[Dreamquick]

If you mean can you read about SQL Server 7 and directly apply that knowledge to SQL Server 2000 then yes.

2000 is more of an upgrade than a re-write, adding a few new features such as user-defined functions, BIGINT data-type etc. with the biggest change being that you can run multiple instances of SQL Server 2000 on one machine.

- Tony

[JohnWise]

Thanks. I know nothing of databases. However, from what I am gathering, I will need to use an SQL to create the site I want.
I noticed a book on SQL that says, "updated with coverage of the SQL:1999 standard". Wondering if buying this and getting familiar will help me?
Once again, thanks.

[Dreamquick]

Oh ANSI SQL Standards from 1999!

Most SQL implementations use a variation on the ANSI SQL standard so that moving from db engine to db engine involves as little re-learning as possible.

In other words learn ANSI SQL and use it anywhere...

-Tony

[JohnWise]

Can you tell me a good tool to use to create databases to upload to the server? Server has MS SQL 2000. Is that easier than creating the db on the server? Very new with this stuff, as you can tell.
Thanks.

[Xoc]

Creating a local database and moving it to the server is a little tricky. You have to detach the database locally, then copy the file for the database to the server. Then on the server, you need to reattach the file.

You can use several tools to create SQL Server databases. SQL Server itself comes with a Enterprise Manager program. You can also use Access 2000. Or Visual Studio .NET. There are probably others.

[sun818]

With SQL Server, there is a learning curve when it comes to administration. If you are new to SQL, I would start with AccessDB (since you are on a Windows host) and become familiar with manipulating data (i.e. Select, Insert, Update, Joins, etc.) Once you have this base, learning the more complex aspects of SQL Server should be less daunting. Plus, you'll save on hosting fees :) as I'm not aware of any that offer free SQL Server use.

[JohnWise]

Thanks very much for the replies. I am presently waiting for a new system to arrive. It will have XP Pro on it which should allow me to use a tool called Web Matrix Project found at Asp.net.
What would really be nice is this. I have a laptop with W98. Would like to have a tool on it that would allow me to access an SQL database at the server. Any ideas much appreciated.
John

[JohnWise]

Concerning Enterprise Manager. Do you know if it is a free download? And does W98 support it? That would probably be my best shot as my host supports EM. I assume their techs are versed with it.
Also, another site has suggested MSDE. Where can one find a good help source for this tool, or say, EM? I really do much better when I can read text-like material explaining the "how to's". Or buying books that explain.
Thank you very much.

[RZaakir]

I don't think that Enterprise Manager is a free download. I'm 95% sure that it does run under Win98 though. The only way that I've ever seen it is on the SQL Server CD ROM. I've never seen it installed by MSDE though you can manipulate an MSDE DB fine with it.