Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones INTO Identities RE: INTO Identities

  • May 15, 2013 at 8:48 am

    #1615466

    garrett.moffitt (5/15/2013)

    I have a table, Customer, with the CustomerID as an identity. I run this query:

    select

    customerID, count(city) as 'City'

    into CustomerCities

    from Customer

    group by CustomerID

    Does the CustomerCities table have a column with the identity property?

    Maybe. Doesn't have to have one. So I'm not sure how one would give a definitive answer.

    Could just have two int columns.

    Of maybe it's has an identity with Identity_Insert set to on.

    IF the customer ID from Customer are higher then that in Custmercities then it may be an Identity

    You don't understand the question. The "into CustomerCities" creates a new table. The creation process has to set an identity or not set it. This isn't something you control with this statement.