dropdatabase.cmd

基于微软的 ASP.NET+C#开发的PETSHOP(网上宠物店)项目,在性能及开发效率上明显优于基于SUN J2EE框架开发的PETSHOP. 项目包括所有源码及数据库建库脚本,是不错的学习 AS

@Echo Off

REM ***************************************************************************
REM **        File: _DropPetStoreDB.cmd
REM **        Name: Database drop
REM **        Desc: Database uninstall batch file.
REM **
REM **        Date: 11/6/2001
REM **
REM **************************************************************************/

REM Use the following section to set the server and sa password
REM of the SQL Server on which you want to create the database.
set SERVER=localhost
set LOGIN=sa
set PWD=
set DBNAME=petshop

@Echo.
@Echo *******************************************************************************
@Echo * Microsoft.NET PetShop Blueprint Application Database Setup                  *
@Echo *                                                                             *
@Echo *                                                                             *
@Echo * This script will drop the .NET PetShop database and database objects.       *
@Echo * If you wish to cancel, press [CTRL]-C and terminate the batch job.          *
@Echo *                                                                             *
@Echo *******************************************************************************
@Echo. 
pause

@Echo.
@Echo.
@Echo *******************************************************************************
@Echo * Dropping the Database...                                                    *
@Echo *******************************************************************************
@Echo. 
osql -S %SERVER% -U sa -P %PWD% -d master -i PetShop_DropDatabase.sql

@Echo.
@Echo *******************************************************************************
@Echo *                                                                             *
@Echo * Script Complete                                                             *
@Echo *                                                                             *
@Echo *******************************************************************************
@Echo. 
pause