How to use SQL commands with SQL7 server

[stesvet1]

Hi,

I bought a book about SQL with CD. There was SQL7, I instaled it on my PC. In directories there are *.mdb and *.sql examples.

I understand principle but I do not know such simple thing, how to run SQL-queries in MS SQL7 server.

What should I do?

Stefan


P.S.: When I use mysql I can write sql- commands to phpadmin or from php. But in the case of SQL7 I do not see where can I type SQL-commands.

 

[gmmastros]

Forget about SQL7. It's many years (and several version) out of date. Instead, I recommend you download and install SQL Server Express.

http://www.microsoft.com/sql/editions/express/default.mspx

You can also download and install SQL Server Management Studio Express. This will give you a graphical user interface in which to write queries and configure the database engine.

http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

You should be able to attach the databases from the book to SQL Server Express and run the code examples without any changes.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[stesvet1]

Thank you, I will try it.
Stefan

 

[JackVam]

Start of by attaching teh MDB file (as suggested above) on Express. Then open Management Studion / execute t-sql

All the IT jobs in one place -

http://www.ITjobfeed.com