Goodspeed

导航

12 2007 档案

获取表的记录行数
摘要：SELECT t.name,p.rows FROM sys.indexes AS iINNER JOIN sys.tables AS t ON i.object_id = t.object_idjoin sys.partitions p with(nolock) on i.object_id = p.object_id AND i.index_id = p.index_idWHERE i.type... 阅读全文

posted @ 2007-12-28 15:26 Goodspeed 阅读(565) 评论(0) 推荐(0) 编辑

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 阅读(1109) 评论(0) 推荐(0) 编辑