感兴趣的小伙伴，下面一起跟随编程之家 jb51.cc的小编两巴掌来看看吧！

代码如下:

 
--==================================================================== 
-- sql：数据库压缩语句 
---------------------------------------------------------------------- 
-- Description: 压缩数据库 

-- Modify: x.zhong 
--==================================================================== 
DECLARE @db_name varchar(200) 

--得到当前数据库名称 
declare getdbname cursor for select db_name() 
open getdbname 
fetch getdbname into @db_name 
while @@fetch_status = 0 
begin 
fetch getdbname into @db_name 
end 
close getdbname 
DEALLOCATE getdbname 

--压缩数据库日志 
DUMP TRANSACTION @db_name WITH NO_LOG 
BACKUP LOG @db_name WITH NO_LOG 
DBCC SHRINKDATABASE(@db_name)