摘要:
由手机通讯记录界面想到的问题 SELECT CASE WHEN AA.num=1 THEN AA.Tel ELSE AA.Tel+'('+CASt(AA.num AS VARCHAR(4))+')' END AS 通讯记录,AA.Times FROM ( SELECT a.Tel ,COUNT(*) 阅读全文
摘要:
连续最大: SELECT M.* FROM #temp MINNER JOIN (SELECT ISNULL(A.score,0)-b.score AS score,B.id FROM #temp AS BLEFT JOIN #temp A ON A.id=B.id+1 ) N ON M.id=N. 阅读全文
摘要:
--保存主表 MERGE INTO dbo.DeliveryReceiving AS t USING @ReceiveMainDt AS s ON t.Id=s.id WHEN MATCHED THEN UPDATE SET --一行五个字段 t.Amount=s.Amount,t.OperId=s 阅读全文