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