Query Building.

• sepich.eric

  Say Hey Kid

  Points: 683

  More actions

  March 16, 2011 at 12:29 am

  #248431

  I have a table called 'Recent_Upload' that contains 52 fields. I want to copy that table to a new table and add a unique key to it. Can this be done by executing one query? What would a query like that look like?

  Thank you!

• ColdCoffee

  SSC-Dedicated

  Points: 39972

  More actions

  March 16, 2011 at 12:34 am

  #1299230

  How about this?

  SELECT IDENTITY(INT, 1, 1 ) AS ID , Col1 , Col2 ......Col52

  INTO New_Table

  FROM Old_Table

  CREATE UNIQUE NONCLUSTERED INDEX IDX_New_Table_ID

  ON New_Table(ID)

• sepich.eric

  Say Hey Kid

  Points: 683

  More actions

  March 16, 2011 at 12:40 am

  #1299233

  At first glance I can understand generally everything except 'IDENTITY(INT 1, 1)'. What is that doing exactly?

• ColdCoffee

  SSC-Dedicated

  Points: 39972

  More actions

  March 16, 2011 at 12:46 am

  #1299235

  Thats a function much like your normal IDENTITY property of a column.

  You can refer and learn more about that function HERE

  I'am sorry , i am actually in the middle of completing a work, so cant explain in detail abt the function. When done with the task, i ll come back to explain

• sepich.eric

  Say Hey Kid

  Points: 683

  More actions

  March 16, 2011 at 1:09 am

  #1299238

  I read the documentation and it's very clear. Thank you very kindly for this wonderful post.