摘要： 1、加索引，只能针对百万左右数据量 2、分表，每个月的数据归档到一个新表按月保存，查询时使用union连查 阅读全文

摘要： SELECT * FROM (SELECT tt.*, ROWNUM AS rowno FROM ( SELECT t.vin_mt ,dbxx FROM {PdaCommonAppService.PREFIX}v_pj_dygx t WHERE vin_jj like '%{input.vin_j 阅读全文

摘要： select rand(CHECKSUM(NEWID())) 阅读全文

摘要： windows平台访问远程服务器共享目录下的access数据库文件 public class SharedDirectoryManager { // logon types private const int Logon32_Logon_Interactive = 2; private const 阅读全文

摘要： SELECT TableName = CASE WHEN A.colorder = 1 THEN D.name ELSE '' END, PrimaryKey = CASE WHEN EXISTS ( SELECT 1 FROM sysobjects WHERE xtype = 'PK' AND p 阅读全文

摘要： SELECT TableName = CASE WHEN A.colorder = 1 THEN D.name ELSE '' END, PrimaryKey = CASE WHEN EXISTS ( SELECT 1 FROM sysobjects WHERE xtype = 'PK' AND p 阅读全文

摘要： 单主键 with T as( SELECT ROW_NUMBER() over (PARTITION By 工件号 order by 检测时间 desc) as rowid,* FROM 检测表 ) delete from T where id not in( select id from T wh 阅读全文

摘要： select msd.*,sc.* FROM MachinesShiftDetails as msd OUTER APPLY (select top 1 * from ShiftCalendars where MachineShiftDetailId = msd.Id) as sc 阅读全文

摘要： with TS as( SELECT ROW_NUMBER() over (PARTITION By code order by code) as rowid,* FROM StateInfos ) select [Hexcode] ,[DisplayName] ,[Code] ,[Original 阅读全文

摘要： 查询存在某个属性的记录 db.getCollection('Machine').find({LineCapacityCount:{ $exists: true }}) 删除Machine文档中 Parameter对象的STD::STATUS属性， {} 表示所有 {"multi":true} 表示多 阅读全文