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 |
|
u2p_inst
Yak Posting Veteran
78 Posts |
 Posted - 2002-07-23 : 04:48:43
|
| dear alli have a problem when i delete the record.i lose my ID(auto number), but The ID still needed before deleted | after deleted -- --ID ID-- --1 12 23 ---> 44 55 66can i delete the record without delete the ID?oh |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-07-23 : 04:57:41
|
| You can update the rest of the fields in the table to null for the particular ID, but I cannot see why you would want to do this???PeaceRick |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-23 : 09:27:23
|
quote:
can i delete the record without delete the ID?
No. DML (Data Modification Language) in relational theory is performed on a entire tuple (set of rows, records, lines) at a time.<O> |
|
|
|
|
|
|
problem with ID in myTable