SQL Server updating a time stamp column

by

You don’t

The timestamp column is updated automatically. Perhaps you are under the impression that timestamp contains a value relating to the time? It doesn’t, but simply is a number which is updated whenever a value in that record is. Think of it like a row version number.

From MSDN:

The timestamp data type is just an
incrementing number and does not
preserve a date or a time.

More Related Contents:

  1. Get the mentioned output by SQL query
  2. I need help formatting inner join command in SQL query
  3. Calculate a Running Total in SQL Server
  4. LIMIT 10..20 in SQL Server
  5. SQL transpose full table
  6. How to Create a real one-to-one relationship in SQL Server
  7. Select statement to find duplicates on certain fields
  8. Getting only Month and Year from SQL DATE
  9. How to fetch the row count for all tables in a SQL SERVER database [duplicate]
  10. WHERE Clause vs ON when using JOIN
  11. Using a Variable in OPENROWSET Query
  12. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  13. Does MS SQL Server’s “between” include the range boundaries?
  14. Check for file exists or not in sql server?
  15. How to get the first and last date of the current year?
  16. Split one column value into multiple column values
  17. SQL Server PIVOT perhaps?
  18. Why execute stored procedures is faster than SQL query from a script?
  19. Merge row values into a CSV (a.k.a GROUP_CONCAT for SQL Server)
  20. Know relationships between all the tables of database in SQL Server
  21. SQL Server *= Operator?
  22. Difference between “read commited” and “repeatable read” in SQL Server
  23. How to escape square brackets inside square brackets for field name
  24. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  25. Select SQL Server database size
  26. Cannot Resolve Collation Conflict
  27. How to set a default row for a query that returns no rows?
  28. Group consecutive rows of same value using time spans
  29. Conditional aggregation performance
  30. SQL add filter only if a variable is not null

Leave a Comment