看到一段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