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.

Define Check points and End Points?

1 Answers  

How to drop an existing user defined function in ms sql server?

0 Answers  

How to return the second 5 rows in ms sql server?

0 Answers  

Is port 1433 secure?

0 Answers  

What does it mean to normalize data?

0 Answers  

What happens if null values are involved in arithmetic operations?

0 Answers  

how can i view structure of table in sql server? tell me that query.

10 Answers  

What are the steps to insert a table?

0 Answers  

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

What is msdb database? : SQL Server Architecture

0 Answers  

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

What happens if null values are involved in datetime operations?

0 Answers