MySql := 'create database aaa on primary(name='aaa_data' filename='d:\aaa_data.mdf',size=10MB,filegrowth=10%) log on(name='aaa_log',filename='d:\aaa_log.ldf',size=2MB,filegrowth=5%,maxsize=5MB)' with ADOQuery do begin close; sql.clear; sql.text := MySql; try ExecSQL; except end; end;
var
qryInstall:TADOQuery ;
DBConnectionString, SQLStr, dbName: String;begin
dbName :='test';
DBConnectionString :='Provider=SQLOLEDB.1;Password=121314';
DBConnectionString :=DBConnectionString +';Persist Security Info=True;User ID=sa';
DBConnectionString :=DBConnectionString +';Initial Catalog=master;Data Source=localhost';
qryinstall := TADOQuery.Create(nil);
try
qryinstall.ConnectionString :=DBConnectionString;
SQLStr :='create database '+dbName;
with qryinstall do
begin
close;
sql.clear;
sql.Add(SQLStr);
try
execsql;
except
end;
end;
finally
qryinstall.Free;
end;
with ADOQuery do
begin
close;
sql.clear;
sql.text := MySql;
try
ExecSQL;
except end;
end;
我已经成功的实现了数据库的创建和备份恢复功能。谢谢。