Use iSQL for SQL Server 2000 command lines

In order to facilitate development at home, I specially designed an old database to bring it back for testing. To maximize performance and save disk space, when installing SQL Server 2000 + SP4, we chose "minimal installation ".

After the installation is complete, all the graphical tools are not installed because they are minimized, including the Enterprise Manager and query analyzer.

In order to build the environment, I had to sacrifice the killer. Use the command line tool iSQL to complete basic operations. To be honest, iSQL is actually a very good thing, this is especially used when you perform automatic processing or other scripts.

Not much to mention, start:

> ISQL-USA-P ***
1> Create Database [test]
2> go
Message indicating success
1> Restore database [test] from disk = 'd: \ test. Bak'
2> go
Execution prompt data
1> quit

In this way, the database is created and restored, and the test starts ......