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.

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

select names starts with a,b,c

8 Answers   Scope International,

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,

Do you know what is user defined datatypes and when you should go for them?

0 Answers  

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

Who is the owner of a schema in ms sql server?

0 Answers  

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

When I run the sql server 2000 setup, it just hangs. What do I do?

0 Answers  

how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

explain different levels of normalization? : Sql server database administration

0 Answers