【正确答案】USE master;
GO
--获取SQL Server数据存储路径
DECLARE@data_path nvarchar(256);
SET@data_path=(SELECT SUBSTRING(physical_name,1,
CHARINDEX(N'master.mdf',LOWER(physical_name))-1)
FROM master.sys,master_files
WHERE database_id=1 AND file_id=1);
EXECUTE(
'ALTER DATABASE AdventureWorks
ADD LOG FILE
(
NAME=test1log2,
FILENAME='"+@data_path+'test2log.1df",
SIZE=5MB。
MAXSIZE=100MB。
FILEGROWTH=5MB
),
(
NAME=test1log3,
FILENAME='"+@data_path+'test3log.1df",
SIZE=5MB,
MAXSIZE=100MB,
FILEGROWTH=5MB
)'
);
GO
【答案解析】