这样的创建数据库问题,请帮忙!谢谢
CREATE DATABASE [test] ON (NAME = N'test_Data', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL\data\test_Data.MDF' , SIZE = 8, FILEGROWTH = 10%)
LOG ON (NAME = N'test_Log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL\data\test_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS
怎样把 c:\Program Files\Microsoft SQL Server\MSSQL\data\ 替换成由
select reverse(substring(reverse(filename),charindex('\',reverse(filename)),len(reverse(filename))))
from sysfiles where right(rtrim(filename),3) = 'mdf' 得到的文件夹?
谢谢!