469,622 Members | 2,199 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

Two timestamp datatypes in single table of SQL server2005

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
}
Mar 19 '08 #1
2 1668
deepuv04
227 Expert 100+
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]
Mar 19 '08 #2
ck9663
2,878 Expert 2GB
Here's the complete CREATE TABLE syntax.

-- CK
Mar 19 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Patrick Hatcher | last post: by
1 post views Thread by Vilson farias | last post: by
5 posts views Thread by Vai2000 | last post: by
4 posts views Thread by Mark Harrison | last post: by
6 posts views Thread by Scott Nixon | last post: by
7 posts views Thread by JJ | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.