create database testDB
on primary
(
name = testdataa,
filename='D:\testdataa.mdf',
size = 4,
maxsize=10,
filegrowth=10%
)
log on
(
name = testlogfile,
filename='D:\testlogfile.ldf',
size=1,
maxsize=4,
filegrowth=10%
)其中的testDB是数据库名,如果要在程序运行的时候,通过在 edit 中输入数据库名来指定呢??
on primary
(
name = testdataa,
filename='D:\testdataa.mdf',
size = 4,
maxsize=10,
filegrowth=10%
)
log on
(
name = testlogfile,
filename='D:\testlogfile.ldf',
size=1,
maxsize=4,
filegrowth=10%
)其中的testDB是数据库名,如果要在程序运行的时候,通过在 edit 中输入数据库名来指定呢??
s1 : string;
sql : string;
begins1 := edit1.text;sql := 'create database ' + s1 + '...';
// ... 就是
on primary
(
name = testdataa,
filename='D:\testdataa.mdf',
size = 4,
maxsize=10,
filegrowth=10%
)
log on
(
name = testlogfile,
filename='D:\testlogfile.ldf',
size=1,
maxsize=4,
filegrowth=10%
)
end;
on primary
(
name = testdataa,
filename='D:\testdataa.mdf',
size = 4,
maxsize=10,
filegrowth=10%
)
log on
(
name = testlogfile,
filename='D:\testlogfile.ldf',
size=1,
maxsize=4,
filegrowth=10%
)
然后通过字符串替换,将这个stringlist里面第一行的原来数据库名字替换为edit.text,然后在放到query里面即可