07 2019 档案
摘要:https://blog.csdn.net/kk185800961/article/details/71158711 检查分发到订阅数据库的更新数据命令执行计划 https://www.cnblogs.com/kerrycode/p/4266646.html
阅读全文
摘要:ALTER DATABASE test SET RECOVERY SIMPLE WITH NO_WAITALTER DATABASE test SET RECOVERY SIMPLE --简单模式DBCC SHRINKFILE (N'test_Log' , 1, TRUNCATEONLY) -- 1
阅读全文
摘要:DECLARE @DBName varchar(255) DECLARE @DATABASES_Fetch int DECLARE DATABASES_CURSOR CURSOR FOR select DATABASE_NAME = db_name(s_mf.database_id) from sys.master_files s_mf ...
阅读全文
摘要:产成品出库的单价要根据订单号和存货编码引用产成品入库的单价 方法一:使用Index 和Match =INDEX(产成品入库!I2:P13 ,IF( MATCH(J2,产成品入库!I2:I13,0)=MATCH(产成品出库!K2,产成品入库!J2:J13,0) ,(MATCH(J2,产成品入库!I2:
阅读全文