sql 2000 数据库重命名 EXEC sp_renamedb '老数据库名字', '新数据库名字 清除日志 dump transaction fy_erp2 with no_log backup log fy_erp2 with no_log dbcc shrinkdatabase(fy_erp2) 四舍五入 update kct03 set kcczsl = select round(3.58,0,1) select round(3.58,0,0) select floor(3.58) select ceiling(3.58) select * from kct04 where kczksl%1>0