WoodleySaint Posted May 14, 2014 Share Posted May 14, 2014 (edited) I would like to add some rows to an existing table in MS SQL server 2005 which has 3 columns: ProviderCodeRef (PK, int, not null) ManagerRef (int, not null) UnitPriceRef (int, not null) The current last row is as follows: ProviderCodeRef ManagerRef UnitPriceRef 164000790 164000598 164000891 If I run the following the record will be added. Insert into ProviderCodes (ProviderCodeRef,ManagerRef,UnitPriceRef) values ('164000791','164000110','164005000'); so the last 2 rows are now ProviderCodeRef ManagerRef UnitPriceRef 164000790 164000598 164000891 164000791 164000110 164005000 If I try an add a record to this table using the application GUI it throws up an error. If I add the record with the following, thereby leaving a gap in the ProviderCodeRefs. Insert into ProviderCodes (ProviderCodeRef,ManagerRef,UnitPriceRef) values ('164000800','164000110','164005000'); I can add a record with the GUI but it is assigned the ProviderCodeRef 164000791 so the table now looks like this: ProviderCodeRef ManagerRef UnitPriceRef 164000790 164000598 164000891 164000791 164000300 164000251 164000800 164000100 164005000 I would be able to add a further 8 records using the GUI but it would then throw an error. How can I make the table use a specific ProviderCodeRef for the next record added with the GUI? Thanks for any advice. Edited May 14, 2014 by WoodleySaint Link to comment Share on other sites More sharing options...
davej Posted May 14, 2014 Share Posted May 14, 2014 See... http://www.w3schools.com/sql/sql_autoincrement.asp Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now