hi

I have a table, and contains one coloum  with timestamp data type,

so i can retrieve timestamp coloum data by executing following query

select CONVERT (int, timestamp_coloum ) from MyTable
 

Query result as follow 

4003
4017
4036
4041... etc......

I just want to know is this result ( out put vale after converted timestamp to INT ) is unique for entire Database ???

 

The short answer to your question is: yes and no.    If you use SELECT INTO using timestamp as part of SELECT list, you will get duplicate entries. Otherwise it will be unique within the database. Each time when you make a change the current timestamp is updated and it will never be used within the database. The timestamp column is binary(8).  So I recommend you to convert it to bigint instead of int.

However,  the current value will not be changed in anyway, unless you insert or update a row of a table which has timestamp column.

You can get the current timestamp value using @@DBTS()

 

---

G.R.Preethiviraj Kulasingham MCITP: DBA
http://preethiviraj.blogspot.com/
Plan Your Work and Work Your Plan!

Thanks lot Preethiviraj for you'r reply

i really going to use this concept in replication environment  

 

Thanks

IndikaD