1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| -- paramètres :
DECLARE @db_name sysname = N'MaBase', @datafile NVARCHAR(32) = N'DataMaBase', @logfile NVARCHAR(32) = N'JTMaBase', @path NVARCHAR(100) = 'C:\databases\SQL Server\'
-- code :
DECLARE @SQL NVARCHAR(max) = N'CREATE DATABASE [' + @db_name + N'] ON
( NAME = ''' + @datafile + ''',
FILENAME = ''' + @path + @datafile + ''',
SIZE = 400 MB,
FILEGROWTH = 50 MB )
LOG ON
( NAME = ''' + @logfile + ''',
FILENAME = ''' + @path + @logfile + ''',
SIZE = 100 MB,
FILEGROWTH = 25MB ) ;'
EXEC (@SQL) |
Partager