declare @strSql varchar(5000);
declare @name varchar(100);
set @strSql='exec sp_attach_db @dbname = ''P_DataBaseName'', @filename1 = ''D:\ETM\ETM_Data\P_DataBaseName.mdf'', @filename2 = ''D:\ETM\ETM_Data\P_DataBaseName_log.ldf''';
Declare addDatabase Cursor For
select databasename from c_store
Open addDatabase
Fetch From addDatabase into @name
While @@Fetch_Status=0
Begin
print REPLACE(@strsql,'P_DataBaseName',@name);
-- REPLACE(@strsql,'P_DataBaseName',@name);
Fetch From addDatabase into @name
End
--关闭/释放游标
Close addDatabase
Deallocate addDatabase