批量生成附加数据库语句

 


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