create database ??
on primary(
name = ''??'',
filename = '??',
size = 100,
maxsize = 1000,
filegrowth = 20
)
log on(
name = '??',
filename ='??',
size = 50MB,
maxsize = 300MB,
filegrowth = 10MB
)'
exec (@aSQL)
go
--将数据库日志设为当达到CheckPoint时自动清空
sp_dboption @dbname='db_61236',@optname='trunc. log on chkpt',@optvalue='true'
go
use ??
go
/*Create Tables*/
-------------------------------------------------------
create table a( ....
)
go
create table B(....
)insert a values (..)
insert b values (..)
go
on primary(
name = ''??'',
filename = '??',
size = 100,
maxsize = 1000,
filegrowth = 20
)
log on(
name = '??',
filename ='??',
size = 50MB,
maxsize = 300MB,
filegrowth = 10MB
)'
exec (@aSQL)
go
--将数据库日志设为当达到CheckPoint时自动清空
sp_dboption @dbname='db_61236',@optname='trunc. log on chkpt',@optvalue='true'
go
use ??
go
/*Create Tables*/
-------------------------------------------------------
create table a( ....
)
go
create table B(....
)insert a values (..)
insert b values (..)
go
代表NVARCHAR的意思。