Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wawansur
Starting Member
44 Posts |
 Posted - 2009-07-27 : 00:11:35
|
| what the meaning of timestamp? with example, please....Rgds |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-27 : 00:41:15
|
tried looking up the BOL ? http://msdn.microsoft.com/en-us/library/aa260631%28SQL.80%29.aspxDon't use timestamp.From SQL 2000 BOLquote:
A future release of Microsoft® SQL Server™ may modify the behavior of the Transact-SQL timestamp data type to align it with the behavior defined in the standard. At that time, the current timestamp data type will be replaced with a rowversion data type.
also refer to SQL 2005 BOL on timestamphttp://msdn.microsoft.com/en-us/library/ms182776%28SQL.90%29.aspx
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
wawansur
Starting Member
44 Posts |
Posted - 2009-07-27 : 01:02:47
|
quote:
Originally posted by khtan
tried looking up the BOL ? http://msdn.microsoft.com/en-us/library/aa260631%28SQL.80%29.aspxDon't use timestamp.From SQL 2000 BOLquote:
A future release of Microsoft® SQL Server™ may modify the behavior of the Transact-SQL timestamp data type to align it with the behavior defined in the standard. At that time, the current timestamp data type will be replaced with a rowversion data type.
also refer to SQL 2005 BOL on timestamphttp://msdn.microsoft.com/en-us/library/ms182776%28SQL.90%29.aspx
KH[spoiler]Time is always against us[/spoiler]
But i used timestamp data type for all my data as identity data.I always get problem with this data type.How to resolve this problem.I used timestamp data for sort my dataRgds |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-27 : 01:19:40
|
you should use integer or decimal with identity instead
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
timestamp