02 2019 档案
sqlserver 更新通过 select 查询出的结果集
摘要：update Babies set BirthOrder =tb.sn from Babies b1, (select ROW_NUMBER() over (partition by familyid order by BirthOrder ) as sn,id,FamilyId,BirthOrde
阅读全文
sqlserver 组内排序
摘要：关键词 partition（分区函数[pɑː'tɪʃ(ə)n]） by 参考： https://www.cnblogs.com/sanlang/archive/2009/03/24/1420360.html http://help.finereport.com/doc-view-1763.html
阅读全文
EF ++属性会更新实体
摘要：var lastBaby = await _babyRepository.FirstOrDefaultAsync(); ++lastBaby.sort; -- sort原本为1 -- 最终会生成一条语句更新sort字段 exec sp_executesql N'SET NOCOUNT ON;UPDA
阅读全文
