SQL Server: Cannot insert an explicit value into a timestamp column

by

According to MSDN, timestamp

Is a data type that exposes automatically generated, unique binary
numbers within a database. timestamp is generally used as a mechanism
for version-stamping table rows. The storage size is 8 bytes. The
timestamp data type is just an incrementing number and does not
preserve a date or a time. To record a date or time, use a datetime
data type.

You’re probably looking for the datetime data type instead.

More Related Contents:

  1. SQL Server 2008 – Help writing simple INSERT Trigger
  2. to select all the employees who have joined most recently under king
  3. Unpivot with column name
  4. How can I delete using INNER JOIN with SQL Server?
  5. SQL NVARCHAR and VARCHAR Limits
  6. How to group time by hour or by 10 minutes
  7. Convert varchar into datetime in SQL Server
  8. sql query to return differences between two tables
  9. SQL Joins Vs SQL Subqueries (Performance)?
  10. Check if a row exists, otherwise insert
  11. How to do pagination in SQL Server 2008
  12. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  13. How can I insert values into a table, using a subquery with more than one result?
  14. formula for computed column based on different table’s column
  15. SQL comments on create table on SQL Server 2008
  16. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  17. How to write UPDATE SQL with Table alias in SQL Server 2008?
  18. SQL Server 2008- Get table constraints
  19. SQL SERVER: Get total days between two dates
  20. Restrict an SQL Server connection to a specific IP address
  21. How does this CASE expression reach the ELSE clause?
  22. SQL speed up performance of insert?
  23. postgresql: INSERT INTO … (SELECT * …)
  24. Store multiple bit values in a single table column
  25. SQL Server equivalent to MySQL enum data type?
  26. Grant SELECT permission on a view, but not on underlying objects
  27. Using IF ELSE statement based on Count to execute different Insert statements
  28. Restrict varchar() column to specific values?
  29. How to execute a stored procedure inside a select query
  30. How to bulk insert only new rows in PostreSQL

Leave a Comment