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 |
|
haibec
Yak Posting Veteran
54 Posts |
 Posted - 2007-02-21 : 01:25:44
|
| I have a table Class include field ID,Name,Email. With ID field.All data not Autocrement ! I want Update ID field autocrement . Please help me |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-21 : 01:36:17
|
| You can not update an auto-increment field, but you can delete and re-insert data with new identity values by setting IDENTITY_INSERT ON.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
haibec
Yak Posting Veteran
54 Posts |
Posted - 2007-02-22 : 01:23:17
|
quote:
Originally posted by harsh_athalye
You can not update an auto-increment field, but you can delete and re-insert data with new identity values by setting IDENTITY_INSERT ON.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
Okie. Thank you |
|
|
|
|
|
|
Update ID field autocrement!help me