无法执行COMPUTE语句 [英] Can't execute a COMPUTE statement

问题描述

我尝试在Northwind数据库上执行这个简单语句

I am trying to execute this simple statement on Northwind database

USE Northwind
SELECT  productid, orderid,quantity 
FROM [order details]
ORDER BY productid, orderid
COMPUTE SUM(quantity)
GO

但我无法执行，我收到此错误

But I this can't execute , I got this error

，Level 15，State 1，Line 5

关键字'COMPUTE'附近的语法不正确。

推荐答案

COMPUTE子句是 SQL Server 2012中不再支持的。该文档建议改用 ROLLUP 。

The COMPUTE clause is no longer supported in SQL Server 2012. The documentation suggests using ROLLUP instead.

这篇关于无法执行COMPUTE语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！