摘要: CREATE TABLE #databaseNames(name varchar(100)NOTNULL,db_size varchar(50),ownervarchar(50),dbidint,created date,statustext,compatibility_levelint);INSERT #databaseNamesexecsp_helpdb;-- Just modify the string after like below:DECLARE dropCur CURSORFOR SELECT name FROM #databaseNames WHERE name like 阅读全文
posted @ 2012-06-27 14:22 Melissa_00 阅读(223) 评论(0) 推荐(0)