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 |
|
Eduard
Starting Member
5 Posts |
 Posted - 2004-07-29 : 05:13:13
|
| I read a some articles alerting about the use of timestamp in SQL server tables, but I don't really know what are the exact reasons why timestamp is so bad. Someone could explain me the reasons?Another question, when you alter a non empty table to add a timestamp column the column is automatically populated. It means that timestamp is an internal property of every row? It doesn't matter if you have a timestamp column or not that this information is stored in every row? The last one, some articles alert about timestamp is not the time the row was inserted or last updated. My question, is timestamp useful to have ordered by insertion or modification time the rows of a table? In others words, timestamp is not the time but is something i can use as a time? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-07-29 : 06:01:17
|
| timestamp is incremented for every tr log entry so will be in order of the update and be unique for every row.When you add the column it is populated from this count as it updates each row.You can use it to find the order of updates - it is useful for doing data transfers - everything with a timestamp greater than the last transfer has been changed.They're not bad but people think they should be a datetime.They stop you creating partitioned views but that's about it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Eduard
Starting Member
5 Posts |
Posted - 2004-07-29 : 07:02:31
|
| Thks! |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-29 : 08:11:13
|
| Eduard, try not to double post in the future. It's annoying and not considered "proper" in the forums. :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Questions about timestamp column