Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    115

    Unanswered: create new table by "select into" without "copying" the identify nature

    pls advise how to create new table by "select into" without "copying" the identify nature to this new table if source table contains identity columns.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    use a function on the id column
    e.g. select id+0 as id, col2, col3 into #t1 from ....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •