Two timestamp datatypes in single table of SQL server2005

[mndprasad]

Hi

i need to give two timestamp datatype in a single table of sql server 2005 DB..but it is showing error that it is not possible..pls anyone help me...

my table::

create table
{
intime timestamp null,
outtime timestamp null
}

[deepuv04]

Hi

i need to give two timestamp datatype in a single table of sql server 2005 DB..but it is showing error that it is not possible..pls anyone help me...

my table::

create table
{
intime timestamp null,
outtime timestamp null
}

[code =text]
I think you are missing the table name ,
use ( instead of { and
you can use datetime datatype instead of timestamp



[/code]

[ck9663]

Here's the complete CREATE TABLE syntax.

-- CK