August 1, 2005 at 3:10 am
Hello once again,
What is the use of 'collate', how effectively can v use that, Likewise what is the use of 'timestamp' datatype
August 1, 2005 at 3:24 am
COLLATE is used to specify that a character string or column (of some character type) should use a specific collation.
Timestamp is a (bad) synonym for rowversion. You should use rowversion instead since that specifies much better what it really does. You can use rowversion datatype for creating an optimistic locking mechanism. What it does is that it 'stamps' every row with a unique version number, and that number (it is not really a number but really a binary) is updated every time a row is modified. That way you can compare the rowversion a row had when it was read to what it is at a later moment and thereby see if the row has been modified since it was read.
Please look up these topics in Books Online for more information, they are very well documented.
August 8, 2005 at 3:10 am
Thanq chris, now only i saw ur reply.Thans a lot
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply