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 to create prepared statements using odbc_prepare()?

0 Answers  

Explain the difference between control flow and data flow?

0 Answers  

What is the maximum rows in sql server table?

0 Answers  

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

what is joins please explain breffly ??

1 Answers   Adaequare, TCS,

How do I view views in sql server?

0 Answers  

Name the different type of indexes in sql?

0 Answers  

Write a sql query to delete duplicate records from a table called table1

0 Answers  

What is exporting utility?

0 Answers  

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

How do I save a stored procedure in sql server?

0 Answers  

What does Master database contains?

0 Answers   Abacus,