use of Timestamp

[tapks]

Hi!

How to use timestamp in the table? What is the advantages of the use? Can I get some samples or sites from when I can get info on it.

Thanks in advance
Tapks

 

[sguslan]

TIMESTAMP data type is meant for tracking updates/inserts into a table. It is an automatically generated binary piece of data that is unique within a given table. It can not be used to indicate time or datetime as its name may imply.

There can only be ONE timestamp column within a table.

You can use it to know what row has been updated or inserted last. A row with the maximum value in the timestamp column is the last row to be updated...

 

[tapks]

Thanks for the answer. Can I get some URL or example from where I can get some more info on it.

 

[DaveStL]

Take a look at the Microsoft Knowledgebase Article Q44415 at

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q44415

 

[sguslan]

Also, SQL ships with SQL Books Online. Great resource for finding info on sql. You can search it on any subject you like....It is normally installed at Start->Programs->Sql Server->Books Online.