日期:2014-05-19  浏览次数:20569 次

看到一段sql语句,不知道什么是据库的??
sql   server?
oracle?
mysql
搞不懂~~

/******   Object:     Database   mr         Script   Date:   2006-12-21   14:19:55   ******/
IF   EXISTS   (SELECT   name   FROM   master.dbo.sysdatabases   WHERE   name   =   N 'mr ')
DROP   DATABASE   [mr]
GO

CREATE   DATABASE   [mr]     ON   (NAME   =   N 'mr_Data ',   FILENAME   =   N 'C:\sqlSERVER\DATA\mr.mdf '   ,   SIZE   =   143,   FILEGROWTH   =   10%)   LOG   ON   (NAME   =   N 'mr_Log ',   FILENAME   =   N 'C:\sqlSERVER\DATA\mr_log.ldf '   ,   SIZE   =   379,   FILEGROWTH   =   10%)
  COLLATE   Chinese_PRC_CI_AS
GO

exec   sp_dboption   N 'mr ',   N 'autoclose ',   N 'false '
GO

exec   sp_dboption   N 'mr ',   N 'bulkcopy ',   N 'false '
GO

exec   sp_dboption   N 'mr ',   N 'trunc.   log ',   N 'false '
GO

exec   sp_dboption   N 'mr ',   N 'torn   page   detection ',   N 'true '
GO
.......

------解决方案--------------------
sql server?

------解决方案--------------------
可以確定是MS SQL的
------解决方案--------------------
mssql server
------解决方案--------------------
sqlSERVER
------解决方案--------------------
/****** Object: Database mr Script Date: 2006-12-21 14:19:55 ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N 'mr ')
DROP DATABASE [mr] --判斷是否存在數據庫mr,存在的話,刪除
GO

CREATE DATABASE [mr] ON (NAME = N 'mr_Data ', FILENAME = N 'C:\sqlSERVER\DATA\mr.mdf ' , SIZE = 143, FILEGROWTH = 10%) LOG ON (NAME = N 'mr_Log ', FILENAME = N 'C:\sqlSERVER\DATA\mr_log.ldf ' , SIZE = 379, FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS --建立數據庫
GO

exec sp_dboption N 'mr ', N 'autoclose ', N 'false ' --變更資料庫選項, 具體可以參考聯繫幫助的sp_dboption,以後相同
GO

exec sp_dboption N 'mr ', N 'bulkcopy ', N 'false '
GO

exec sp_dboption N 'mr ', N 'trunc. log ', N 'false '
GO

exec sp_dboption N 'mr ', N 'torn page detection ', N 'true '
GO