Rowversion

  • 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....

  • I notiiced that min_active_rowversion() is missing in SQL 2005 sp3 developer version .

  • 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

  • Return type for this function is Binary(8).

    You can check out in msdn.

    http://msdn.microsoft.com/en-us/library/bb839514.aspx

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply