Re: Convert help needed desperately

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: CL (cl_at_mail)
Date: 05/14/04 

Date: Thu, 13 May 2004 19:08:27 -0500

It is just getting the current system date and placing it a field that is of
the timestamp data type. I'm trying to do an update query and this is a
required field - and does not accept null
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:Own$yBUOEHA.3044@TK2MSFTNGP10.phx.gbl...
> Unlike its name, timestamp has absolutely nothing to do with time. What
is
> your actual business requirement?
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> .
> "CL" <cl@mail> wrote in message
news:eor1A$TOEHA.556@tk2msftngp13.phx.gbl...
> I have a stored procedure that is throwing an error 291 when I'm trying to
> convert datetime to a timestamp.
>
> The table I am inserting into needs to have a timestamp My code in
question
> looks like this:
>
> , Convert(timestamp(8), getdate()) as upsize_ts
>
> Can any one help to see what I am doing wrong????
>
> CL
>
>

Relevant Pages

  • Re: How to handle concurrency issue with better performance?
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Then for timestamp, it will be unique? ... Collisions occur because your design permits ... select command). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to handle concurrency issue with better performance?
    ... Then for timestamp, it will be unique? ... Hitchhiker's Guide to Visual Studio and SQL Server ... We all work with relational database designs and more ... select command). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to handle concurrency issue with better performance?
    ... Keep in mind that a timestamp column does not store a date/time value. ... Hitchhiker's Guide to Visual Studio and SQL Server ... We all work with relational database designs and more ... select command). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Convert help needed desperately
    ... The timestamp column is useless to you. ... a new column of datatype datetime and populate it with getdate. ... Columnist, SQL Server Professional ... > "Tom Moreau" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: More questions about porting from MySQL to MS SQL
    ... The way to do this in SQL Server is to use a trigger. ... timestamp is not deprecated in SQL Server, ... Not a separate script, but a separate batch. ...
    (comp.databases.ms-sqlserver)