Cannot insert an explicit value into a timestamp column
TimeStamp is used to store unique binary numbers within a database. This column is autogenerated with a storage size of 8 bytes.
CREATE TABLE MyTable(
Name VARCHAR(20),
CreatedOn TIMESTAMP
)
INSERT INTO MyTable(Name,CreatedOn) VALUES('Najmul',GETUTCDATE())
SELECT Name,CONVERT(DATETIME,CreatedOn) FROM MyTable
Msg 273, Level 16, State 1, Line 2
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.