mode con:cols=98 lines=35
color 16
@echo on
@echo ==============================================================
@echo use sqlcmd to create database
@echo please input db server,database,userid,password
@echo ==============================================================
@echo off
set /p srv=please input server :
@echo connect to default database [master]
set /p uid=please input userid :
set /p pwd=please input password :
set /p dbName=please input database Name :
set /p dbPath=please input database file Path :
set dropDb=IF EXISTS(SELECT * FROM sysdatabases WHERE [name]= '%dbName%') DROP DATABASE %dbName%
set createDb= CREATE DATABASE %dbName% ON ( NAME = Sales_dat, FILENAME = '%dbPath%\%dbName%.MDF', SIZE = 10, FILEGROWTH = 5 )LOG ON ( NAME = Sales_log, FILENAME = '%dbPath%\%dbName%.LDF', SIZE = 10, FILEGROWTH = 5 ) COLLATE Chinese_PRC_CI_AS
@echo Server[%srv%] DataBase[master] UserID[%uid%] Password[%pwd%]
@echo start to drop database which has the same name [%dbName%]
@echo %dropDb%
sqlcmd -U %uid% -P %pwd% -S %srv% -d master -Q "%dropDb%"
@echo start to create database [%dbName%]
@echo %createDb%
sqlcmd -U %uid% -P %pwd% -S %srv% -d master -Q "%createDb%"
@echo create database finished
pause