a183635870的博客

文章目录1.SQL Server1.1 查询所在数据库所有表的行数1.SQL Server1.1 查询所在数据库所有表的行数USE [dbname]SELECT a.name, b.rowsFROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.idWHERE (a.type = 'u') AND (b.indid IN (0, 1))ORDER BY a.name,b.rows DESC...

USE[master]GOALTER DATABASE db_Name SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE db_Name SET RECOVERY SIMPLE --简单模式GOUSE db_Name GODBCC SHRINKFILE (N'db_Name_log' , 1, TRUNCATEONLY) --收缩到1MGOUSE[master]GOALTER DATABASE db_Name SET RECOVER