摘要:
--INSERT INTO SELECT FROM INSERT INTO BoxInfo(BoxNo,ItemNo,ItemNoOld,ItemName,ItemSpec) SELECT A.BoxNo,A.ItemNo,B.ItemNoOld,A.ItemName,A.ItemSpec FROM 阅读全文
摘要:
--UPDATE FROM UPDATE BasDeptInfo SET ManagerNo=table2.newno FROM BasDeptInfo,table2 WHERE ManagerNo=table2.oldno 阅读全文
摘要:
--查询死锁 SELECT [session_id], [request_id], [cpu_time], [start_time] AS '开始时间', [status] AS '状态', [command] AS '命令', dest.[text] AS 'sql语句', [reads] AS 阅读全文
摘要:
--压缩日志1 ALTER DATABASE 数据库名 SET RECOVERY SIMPLE DBCC SHRINKFILE (数据库名_Log,0, TRUNCATEONLY) ALTER DATABASE 数据库名 SET RECOVERY FULL --压缩日志2 ALTER DATABAS 阅读全文