摘要：1.当月每一天的汇总 SELECT SUM(Qty)Qty , DATEPART(DAY,pickDate) Pickday FROM dbo.Delivery WHERE DATEDIFF(MONTH, pickDate, GETDATE()) < 1 GROUP BY DATEPART(DAY, 阅读全文

摘要：1.先分页获取数据，然后再查询一遍数据库获取到总数量 2.使用count(1) over()获取总记录数量 SELECT * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY Id DESC) rn, COUNT(1) OVER() AS TotalCount, Id 阅读全文

摘要：eg：update A set InAmount =b.InAmount from A a inner join B b on( a.ID=b.PRID) 阅读全文

摘要：/******返回传入的字符串的所有字符 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER function [dbo].[F_Get_Letter](@Letter NVARCHAR(100))RETURNS NVARCHAR(10... 阅读全文

摘要：--把查询的结果组织为一串字符(板板鞋,兵乓球,篮球,足球)drop table a create table a( name varchar(20)) insert into a select '足球' union select '篮球' union select '兵乓球' union sele... 阅读全文