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 |
|
mruncola
Starting Member
1 Post |
 Posted - 2004-08-28 : 13:09:44
|
| I am trying to create a database that will version old data as data is added or updated. Are there any examples or suggestions of/for this? Is there a difference or compare command for sql server that could help to create difference data?-Thanks! |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-08-28 : 13:31:35
|
| For comparing data have look at binary_checksum(*) or checksum(*) functions.These could be used to check if rows or tables have diffs./rockmoose |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-08-01 : 12:02:21
|
| This doesn't always work it's possible to have different values with same checksum value.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33567&SearchTerms=BINARY_CHECKSUM |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-01 : 12:40:16
|
| ... and I don't think it handles TEXT columns, does it?Kristen |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-08-01 : 13:35:12
|
| I believe Peso has written one that handles images / text.See here.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70328&whichpage=2&SearchTerms=CHECKSUM%2CIMAGE |
|
|
|
|
|
|
Versioning of data