time

From: sara (anonymous_at_discussions.microsoft.com)
Date: 07/25/04 

Date: Sun, 25 Jul 2004 08:54:24 -0700

Hi
i am new in mssql7.before i am using sybase and
some of the tables having field type time.after
convert to mssql7 i changed that field type as timestamp.
i want to store time in that feild.For select and update
query there was no prbm in sybase, but here it is showing
error"The columns data type (columnname)requires the use
of an embedded stmt" and while updating also error is
coming,how can i solve this and store time in table.Please
help
thanks