What is The Use Of TIMESTAMP DataType in SQL Server 2005?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / dinesh sharma

6 Answers
21753 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is The Use Of TIMESTAMP DataType in SQL Server 2005? ..

Answer / deepak rohilla

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

Is This Answer Correct ?

47 Yes

13 No

What is The Use Of TIMESTAMP DataType in SQL Server 2005? ..

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

Is This Answer Correct ?

19 Yes

2 No

What is The Use Of TIMESTAMP DataType in SQL Server 2005? ..

Answer / samar

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

Is This Answer Correct ?

19 Yes

5 No

What is The Use Of TIMESTAMP DataType in SQL Server 2005? ..

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.

Is This Answer Correct ?

9 Yes

1 No

What is The Use Of TIMESTAMP DataType in SQL Server 2005? ..

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

Is This Answer Correct ?

9 Yes

3 No

What is The Use Of TIMESTAMP DataType in SQL Server 2005? ..

Answer / xavier rajan, photon infotech

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

Is This Answer Correct ?

19 Yes

34 No

Post New Answer