how to set up identity after select into is used?

[sql]

Hi I use select into to select part of my data form table1 to table2, after then can I still automatica increase my number one when I insert the new row?
thank you
________
Fzr1000

[skhanal]

Yes, when you do SELECT INTO, identity property of the column is maintained.

[Rawhide]

If you are asking if you can make a column an identity column after inserting data, then no.

You can create a second field that is an identity column, set identity insert on, and insert the values from the column you inserted into previously.

[sql]

Hi, thank you for the replys!
________
Free Wordpress Themes