SQL server 2005 更改数据库名称
摘要:
DECLARE@ttable(spidint)INSERTINTO@tSELECTspidFROMsys.sysprocessesASpWHEREEXISTS(SELECT*FROMsys.databasesWHEREname='ednchina20071202'ANDp.dbid=database_id)DECLARE@spidintDECLARE@sqlnvarchar(max)WHILE((... 阅读全文
posted @ 2007-12-03 17:09 Goodspeed 阅读(1108) 评论(0) 推荐(0) 编辑