sql-server - SQL Server 2008 升级 - 计算计数

Question

我正在将数据库从 SQL Server 2008 升级到 2016，我发现以下 2008 SQL 导致“计算计数”出现语法错误。

我该如何解决这个问题？：

select c.name lab_name, d.name creator_name, e.name mod_name, a.mod_dt 
from u_sample_concrete a, lab b, org c, org d, org e, lab_engr f
where a.mod_dt >= 'jan 1 1996 12:00AM' and
a.lab_cd = b.lab_id and b.org_id = c.org_id and
a.create_uid = f.user_id and f.org_id = d.org_id and
a.mod_uid = f.user_id and f.org_id = e.org_id 
order by c.name, d.name, a.mod_dt
compute count(d.name) by c.name, d.name

标签： sql-serversql-server-2008sql-server-2016