C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Abhi (77)
Appukuttan (40)
raj krishna (37)

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

TimpStamp

Posted Date: 08 Sep 2006	Resource Type: Articles	Category: Databases
Author: Dhvani	Member Level: Silver
Rating:	Points: 10

Time Stamp:
Time Stamp returns the VARBINARY data type data.

Select @@DBTS

Timestamp is actually the transaction identifier within the database. It is either a binary (8) or a varbinary(8) depending on null ability.

It is initialized when the database is created and is incremented whenever a modification occurs within the database. You can view the current value in @@dbts. It does not at all correlate to the time of day.

Way back yonder, Sybase could have more clearly named the data type Transaction Stamp or Transaction Id rather than imply that it has anything to do with time. Microsoft is planning to phase out the timestamp in favor of row version. That change has more to do with ANSI SQL-92 compliance than anything else. Both data types exist in SQL 2005.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Eureka!!! Find ways to extract a particular column value
	Previous Resource: Diffrent types of read in SQL Server
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design