请SQL高手帮忙改个ACCESS查询转SQL

来源：百度知道 编辑：UC知道 时间：2024/05/19 12:29:19
以下是ACCESS数据库中用的SQL查询语句代码,希望你能帮我改成SQL SERVER中视图所用的SQL 查询语句,对SQL SERVER的查询太不熟了,请帮帮忙.谢了
查询一:名:gztongjimonth
内容:SELECT DISTINCTROW Format$([gztongji].[createDate],'mmmm yyyy') AS createDatebymonth, Sum(gztongji.jiben) AS Sumjiben, Sum(gztongji.jiangjin) AS Sumjiangjin, Sum(gztongji.koushui) AS Sumkoushui, Sum(gztongji.sanjin) AS Sumsanjin, Sum(gztongji.gongjijin) AS Sumgongjijin, Sum(gztongji.kouxin) AS Sumkouxin, Sum(gztongji.qita) AS Sumqita, Sum(gztongji.totalCount) AS SumtotalCount
FROM gztongji
GROUP BY Format$([gztongji].[createDate],'mmmm yyyy'), Year([gztongji].[createDate])*12+DatePart('m',[gztongji].[createDate])-1;

SELECT DISTINCTROW convert(char(10),gztongji,111)
AS createDatebymonth, Sum(gztongji.jiben) AS Sumjiben, Sum(gztongji.jiangjin) AS Sumjiangjin, Sum(gztongji.koushui) AS Sumkoushui, Sum(gztongji.sanjin) AS Sumsanjin, Sum(gztongji.gongjijin) AS Sumgongjijin, Sum(gztongji.kouxin) AS Sumkouxin, Sum(gztongji.qita) AS Sumqita, Sum(gztongji.totalCount) AS SumtotalCount
FROM gztongji
GROUP BY Format$([gztongji].[createDate],'mmmm yyyy'), Year([gztongji].[createDate])*12+DatePart('m',[gztongji].[createDate])-1;

create view v_1
as
SELECT DISTINCT
Convert(varchar(10),x.createDate,106) AS createDatebymonth,
Sum(x.jiben) AS Sumjiben,
Sum(x.jiangjin) AS Sumjiangjin,
Sum(x.koushui) AS Sumkoushui,
Sum(x.sanjin) AS Sumsanjin,
Sum(x.gongjijin) AS Sumgongjijin,
Sum(x.kouxin) AS Sumkouxin,
Sum(x.qita) AS Sumqita,
Sum(x.totalCount) AS SumtotalCount
FROM gztongji x
GROUP BY
Convert(varc