帮解释一下这段sql语句

来源：百度知道 编辑：UC知道 时间：2024/09/20 23:40:15
con.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa"
con.Open
Set rs = New ADODB.Recordset

str = "EXEC sp_attach_db @dbname = N'db_SSS', @filename1 = N'" + App.Path + "\DataSource\db_SSS_Data.MDF" + "', @filename2 = N'" + App.Path + "\DataSource\db_SSS_Log.LDF" + "'"

Set rs = con.Execute(str)
con.Close

PublicStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=db_SSS"

请老师帮我翻译一下这段代码的意思

con.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa"
--设置连接字符串
con.Open --打开连接
Set rs = New ADODB.Recordset --创建记录集对象

str = "EXEC sp_attach_db @dbname = N'db_SSS', @filename1 = N'" + App.Path + "\DataSource\db_SSS_Data.MDF" + "', @filename2 = N'" + App.Path + "\DataSource\db_SSS_Log.LDF" + "'" --设置一条sql语句，功能是从磁盘指定文件附加一个数据库

Set rs = con.Execute(str) --执行上面的语句并把返回的结果放到rs中
con.Close --关闭连接

PublicStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=db_SSS" --又设置一个连接字符串，连接到刚才附加进来的数据库