By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,360 Members | 1,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,360 IT Pros & Developers. It's quick & easy.

Two timestamp datatypes in single table of SQL server2005

P: 20
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
Share this Question
Share on Google+
2 Replies


deepuv04
Expert 100+
P: 227
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
Expert 2.5K+
P: 2,878
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.