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.

What is function of ROLLUP ?

0 Answers   HCL,

What is #temp and @table variable in SQL server?

0 Answers  

What is the usage of sign function?

0 Answers  

How to create function without parameter in sql server?

0 Answers  

How would you use user_constraints table in DB?

0 Answers   Wipro,

What is a join and their types?

2 Answers   Challenger Financial,

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

What is partition index in sql server?

0 Answers  

Can truncate be rolled back?

0 Answers  

What is msdb database? : SQL Server Architecture

0 Answers  

How do I start sql server?

0 Answers  

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers