SQL Server 2008
SQL Server 2008
Today I was working with RowVersions (aka TimeStamp, aka binary(8)) and tried to update a table with a value I had retrieved and stored by doing select @@DTBS My stored notepad value was ‘0x0000000027A3CC07’ so I had run a query to update a table with it, but it didn’t work, the set value was different (‘0x3078303030303030’). Being puzzled I tried a few queries and all of them returned this unexpected result which explained why my update set the wrong value, examples: Queries select CONVERT(rowversion, '0x0000000027A3CC07') select CONVERT(timestamp, '0x0000000027A3CC07') select CONVERT(binary(8), '0x0000000027A3CC07')...
Just in case anyone missed it SQL Server 2008 has gone RTM and is now available for download in the MSDN Library or through the links listed below: Press Release Trial Download (Full) Free Download (Express) Feature Pack Download (Redistributable components for SQL Server 2008, Add-on providers for SQL Server 2008 and Backward compatibility components for SQL Server 2008) SQL Server Community Features: Its a big deal This is a big deal for us...