Sql Server Identity seed on/off by code
Posted on 2010-11-17
Just like to make you a bit busy.
I am just converting my software from MS-Access to Sql Server 2005 Express Edition. Have to convert all the my clients databases. I set all the create table script and then I import the data from MS-Access to Sql server using Import Export Wizard of Sql Server. Now I like to put identity specification to almost all the tables. Can you let me have the command to turn it on.
Right now I have to modify each table from designer and enable identity. For one time I like to develop a script and will apply the same to other client's database.
I cannot specify identity on at create table as I have to import the data.
Please let me have the possible solution.
Thanks & Best Regards