SET NOCOUNT ON
DECLARE @B_DATE DATETIME
DECLARE @E_DATE DATETIME
DECLARE @DATE DATETIME
DECLARE @DI INT
DECLARE @DATABASE VARCHAR(255)
 
SET @B_DATE='2009-07-01' -- 自定义起始日期
SET @E_DATE='2009-07-16' -- 自定义结束日期
 
 
SET @DATE=@B_DATE
 
WHILE (@DATE<=@E_DATE)
BEGIN
SET @DI=YEAR(@DATE)*10000+MONTH(@DATE)*100+DAY(@DATE)
Declare cur_tbl cursor local for
select name from master.dbo.sysdatabases where name like 'OCULAR3_DATA.'+cast(@DI as varchar(8)) +'%'
open cur_tbl
fetch next from cur_tbl into @database
while @@fetch_status = 0
BEGIN
EXEC SP_DETACH_DB @DATABASE
PRINT @DATABASE + '已分离'
fetch next from cur_tbl into @database
END
close cur_tbl
deallocate cur_tbl
SET @DATE=@DATE+1
END