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