生成批量附加数据库语句

 
declare @dbname varchar(20)  
declare @dir nvarchar(520)
set @dir='D:\Data'
declare my_cursor cursor
for  
    select databasename from etm_chain.dbo.c_store
    open my_cursor
    fetch next from my_cursor into @dbname 
    while  @@fetch_status = 0
    begin 
          print 'exec sp_attach_db @dbname = ' + @dbname + ',@filename1 = ''' + @dir + '\' + @dbname + '.mdf'',@filename2 = ''' + @dir + '\' + @dbname + '_log.ldf'''    


          fetch next from my_cursor into @dbname
    end
close my_cursor
deallocate my_cursor
go