exec('CREATE DATABASE Sales
ON
( NAME = Sales_dat,
FILENAME = '+@drivepath+'''\saledat.mdf'''+',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = '''Sales_log''',
FILENAME = @drivepath+'''\salelog.ldf''',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )')
ON
( NAME = Sales_dat,
FILENAME = '+@drivepath+'''\saledat.mdf'''+',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = '''Sales_log''',
FILENAME = @drivepath+'''\salelog.ldf''',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )')
ON
( NAME = Sales_dat,
FILENAME = '+@drivepath+'''\saledat.mdf'''+',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = '''Sales_log''',
FILENAME = '+@drivepath+'''\salelog.ldf'''+',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )')
应这样:
exec('CREATE DATABASE Sales
ON
( NAME = Sales_dat,
FILENAME = '''+@drivepath+'\saledat.mdf'', SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = ''Sales_log'',
FILENAME = '''+@drivepath+'\salelog.ldf'', SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )')