Answer / deepak rohilla

Timestamp is used typically as a mechanism for version-
stamping table rows.

Answer / professor r.arjunarao

TimeStamp field to detect update collisions in order to
reduce the amount of data sent to the server

example
CREATE TABLE emp (empno int PRIMARY KEY, tax int, TS timestamp)
GO
INSERT INTO emp (empno, tax) VALUES (1, 0)
GO
INSERT INTO emp (empno, tax) VALUES (2, 0)
GO
select * from emp;

1 0 0x0000000000000FA1<---Unique values
2 0 0x0000000000000FA2<---Unique values

Answer / samar

can u plz give example ,
how to use this data type

Answer / brindly

"IS A MECHANISM TO TRACK CHANGES IN TABLE.
IT UPDATE ITSELF WHEN THERE IS A UPDATION IN ROW CONTAING
TIMESTAMP COLUMN"

I accept above answer.
But whether the timestamp field updates itselt in a
incremental fashion.

Answer / deepak tripathi niit

IS A MECHANISM TO TRACK CHANGES IN TABLE.
IT UPDATE ITSELF WHEN THERE IS A UPDATION IN ROW CONTAING
TIMESTAMP COLUMN

Answer / xavier rajan, photon infotech

time stamp data type is used to automatically generate the
unique number.A database-wide unique number.

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  

What is user stored procedure & it purpose?

4 Answers   Wipro,

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

What is open database communication (odbc)?

0 Answers  

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

What is the difference between functions and scalar functions?

0 Answers   EXL,

What is Trace flag?

1 Answers   Wipro,

What is forward - only cursors / read only cursor?

0 Answers  

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

What is compression - row-level and page-level compression?

0 Answers  

What is difference between clustered index and non clustered index?

0 Answers  

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,