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 |
|
vikassethi
Starting Member
2 Posts |
 Posted - 2008-01-10 : 21:22:28
|
| I have been provided with a table where one of the columns is of TimeStamp data type. My question is how to insert and update data in this column through my SQL Statement? When I run my SQL statement, it gives me an error with this column name in the error. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-10 : 22:13:51
|
| You cannot insert into a timestamp column. SQL server does that for you. Thats the purpose of having a timestamp column. Readup books online for more info on timestamp columns.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2008-01-10 : 23:02:30
|
| U cant specify explicitly values for a timestamp column. |
|
|
|
vikassethi
Starting Member
2 Posts |
Posted - 2008-01-10 : 23:46:13
|
| Thanks. That's the impression I had, but I get some error. Let me see the cause of the error in that case. |
|
|
|
|
|
|
Insert data TimeStamp Column in a table