Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
westy
Starting Member
1 Post |
 Posted - 2002-10-09 : 10:43:39
|
| Hello,I have a table with three columns, one a auto number, and the other two contains a street name and an area ID. I am trying to populate this table from the records in another table that has all the streets in each area by postcode or zip code. How do I populate the street_name and area code, but let the auto number column create numbers automatically.ThanksStephen |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-09 : 12:42:39
|
| You want to set the auto number field to identity(1,1)Look up identity in books online. If you got anymore questions after that, post away-----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
|
|
|
Creating and updating a table from other tables