在sql server中创建视图“每个视图或函数中的名称必须是唯一的"

I'm trying to create view in sql server 2012, but I have this error message

Column names in each view or function must be unique. Column name 'Lastname' in view or function 'vFileImportDPERManagers' is specified more than once.

这是我的视图代码:

    GO



CREATE VIEW [dbo].[vFileImportDPERManagers]
    AS
SELECT M.*,
Managers.*

FROM            dbo.vFileImportDPERDebtors M WITH (NOLOCK)
CROSS APPLY 
(
    SELECT
        M1.Man.value('@j11','varchar(20)') as ManagerKey,
        M1.Man.value('@j12','varchar(50)') as Lastname,
        M1.Man.value('@j13','varchar(50)') as Firstname,
        M1.Man.value('@j14','numeric') as ManagerFunctionId


    FROM DebtorXml.nodes('d1/d36/t324/j1') as M1(Man)
) as Managers
GO

推荐答案

在您的情况下，表 dbo.vFileImportDPERDebtors 将有一个名为Lastname"的列.如果您按名称选择所有列(即，将 * 扩展为名称)，您可以为一个或两个姓氏列设置别名，SELECT M.Lastname as Lastname1, Managers.Lastname as Lastname2....通常认为最好的做法是不使用SELECT *".