即

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结果的列没有名称.

解决方法

SELECT OwnerUserId,SUM(Postscore) AS PostscoreSum
INTO Experts 
FROM ...

SELECT OwnerUserId,SUM(Postscore)  PostscoreSum
INTO Experts 
FROM ...

SELECT OwnerUserId,PostscoreSum = SUM(Postscore)  
INTO Experts 
FROM ...

• 上一篇：SQL中的参数 – Delphi 7下一篇：sql-server-2005 – 在SQL Server