atzqtzq的博客

//1.查询表锁，发现无锁定的表show OPEN TABLES where In_use > 0;//2.但执行拿锁的sql时，却提示超时select *From test where id=231 for update;//3.直接查询正在执行的事务SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;//发现有一个，kill线程kill 141148...

1.需求：列表中优先显示自己的数据2.实现,使用order by case whenselect *From orders order by case when userid='123456' then 1 else 0 end desc

1.三元运算符方式 var infoDTO = query.Select((a, b) => new ServiceStatusCountDTO {- ConfirmCount = SqlFunc.AggregateSum(SqlFunc.IIF(a.ServiceStatus== Sea.Enum.OrderFlowStatus.dai_que_ren.GetStringValue(),1,0)),-

1.存储过程create proc query_table_struc@tablenames varchar(5000)asdeclare @table varchar(50)declare @endPosition int declare @subString varchar(5000)set @subString=@tablenamescreate table ##tmp( tablename varchar(50))while(len(@subString)>0)

1.sqlserver 分组排序并插入序号update Master set Master.SortID=t2.rownum from ( select rownum,marginID from ( select row_number() over(partition by OrgID order by price) rownum,* from Master ) as t1) as t2 where t2.marginID=Master.marginID2.sqlserve