September 2, 2008 at 4:47 pm
I got this one wrong, and then when to my analyzer to figure something out.....
SELECT CAST(MIN_ACTIVE_ROWVERSION() AS FLOAT)
If you run this you get the error of Explicit conversion from data type varbinary to float is not allowed......
So why is varbinary not an option....
February 10, 2009 at 5:32 pm
I notiiced that min_active_rowversion() is missing in SQL 2005 sp3 developer version .
April 17, 2010 at 6:05 pm
Steve Jones - Editor (8/13/2008)
The correct answer, according to that link, is a rowversion data type. This may be stored as binary(8), but there is a special type for it as well.
The current page in the online 2005 BoL http://msdn.microsoft.com/en-us/library/bb839514%28SQL.90%29.aspx says it returns binary(8) in the Return Types section. Elsewhere on the same page it calls it a rowversion value and says that another name for it is a timestamp. It's not at all surprising that some people were confused.
Tom
April 21, 2010 at 2:23 am
Return type for this function is Binary(8).
You can check out in msdn.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply