Insert an explicit value into a timestamp column

Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column. Suppose we have created OrderHistory table in current database. CREATE TABLE OrderHistory( OrderId BIGINT PRIMARY KEY, OrderDate TIMESTAMP ) Now if will try to insert some records into the OrderHistory table: INSERT INTO OrderHistory(OrderId,OrderDate) VALUES(100,GETDATE()) We will get error message : Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column. Cause: We cannot insert explicit value in timestamp column in sql server Solution: Correct way to insert : INSERT INTO OrderHistory(OrderId,OrderDate) VALUES(100,DEFAULT) Or INSERT INTO OrderHistory(OrderId) VALUES(100)