sql-server – 如何为SUM列指定名称？

如作甚SUM列分派列名？

即

select OwnerUserId,SUM(PostScore)
INTO Experts
from ...

我收到此错误：

An object or column name is missing or
empty. For SELECT INTO statements,
verify each column has a name. For
other statements,look for empty alias
names. Aliases defined as “” or [] are
not allowed. Change the alias to a
valid name.

我想由于包括SUM功效的列没著名称.

办理要领

至于名称 – 称为别名 – 您可以行使AS.这是尺度的SQL语法：

SELECT OwnerUserId,SUM(PostScore) AS PostScoreSum
INTO Experts 
FROM ...

但AS是可选的,因此您也可以在没有它的环境下为列添加别名：

SELECT OwnerUserId,SUM(PostScore)  PostScoreSum
INTO Experts 
FROM ...

您还可以行使(专有的,仅在SQL-Server中)alias = column语法：

SELECT OwnerUserId,PostScoreSum = SUM(PostScore)  
INTO Experts 
FROM ...

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!