Home Forums SQL Server 2005 SQL Server Newbies How to add an Identity(autocounter) integer field (as Primary key)as first column of a SQL View RE: How to add an Identity(autocounter) integer field (as Primary key)as first column of a SQL View

  • July 2, 2014 at 8:19 am

    #1726517

    Many thanks! Did learn a couple of new things.

    The Identity key worked. And, the Primary Key on a view is not possible.

    The actual problem was that I used a space to define a two word field name. e.g. Well Status vs Well_Status

    It was an accident, my default is to use an underscore rather than a space.

    Interesting enough, the data could be consumed with Native Client 11.0 and standard ODBC (for Access and Excel) but not in a GIS ODBC workstation. They send me a screen shot of the error.

    The error was "Could not load data from data source. Attribute column not found[42S22:[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'Well'.]