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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-07-30 : 11:45:39
|
| kevin writes "I would like to add multiple timestamps columns to a SQL Server table.However I have come up with an error sayingMsg 2738, Level 16, State 37000:[Microsoft][ODBC SQL Server Driver][SQL Server]A table can only have one timestamp column. Because table 'JOB' already has one, the column 'BOOKED_DATE' cannot be added.Does not SQL Server allow multiple timestamp columns in a table.If not is there a Microsoft or SQL Server solution to this or is the answer is to simply put one timestamp column in a table. The issue is that there would have to be a major redesign of many tables, is there an easy solution to this problem.Thanks " |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-30 : 11:48:35
|
| Are you a db2 developer?timestamps don't mean the same thing...and in sql server you can only have 1I think you want dattime columns...and note, sql server only goes to 3 position for microseconds...not 6 like db2Brett8-) |
 |
|
|
|
|
|
Muliple timestamp columns in SQL tables