• UMG Developer (9/23/2010)


    I agree that OrderRefNo is an identifier, but if you look at my comment I was saying that OrderNo is not an identifier:

    OrderNo INT NOT NULL IDENTITY(1,1),

    So there aren't multiple identifiers in the table. Given that "Multiple identifier columns" isn't an option for a principle that the DDL violates.

    Sorry, UMG. You are right. I saw your comment and interpreted it as defending the "no identifier at all" option - my bad, I should have read better.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/