TimeStamp Question

From: Timothy (tim_at_spam.com)
Date: 06/14/04


Date: Mon, 14 Jun 2004 15:12:10 -0600

Does SQL server change/generate the timestamp value each time I update or
insert data into the table? Or do I need to create a new timestamp value on
the client side and send it to my stored procedures?

Thanks



Relevant Pages

  • Re: Database notification
    ... publish/subscribe) to the client. ... MySQL supports for stored procedures. ... You would still need triggers that updates the new timestamp table. ...
    (comp.lang.java.databases)
  • Re: Concurrency Help
    ... The timestamp column is changed whenever ANY data in the row is ... >> An UPDATE operation with a focused WHERE clause is an atomic operation. ... I want to know if a database, ... >>> 1 would overwrite client 2's changes to the db. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: WSE 2.0 time fault while authentication.
    ... There are two thing that you can use to avoid the timestamp problems: ... It is usually the time skew between client and server machine. ... Syncing the client and server clocks is an impossibility in my case. ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: problems inserting a utf8 timestamp with DBD::Oracle
    ... Don't think so as I'm not using Oracle 9. ... Well I'm not saying it isn't a bug in Oracle but this one is a real problem I cannot easily workaround as really I need a timestamp and a date. ... Client is Oracle 10.2.0 XE ... If you then comment out the 2nd block of code and uncomment the 3rd block of code it works i.e it appears it does not like having a timestamp and a date in the same insert. ...
    (perl.dbi.users)
  • Authentication Protocol, is it secure?
    ... the server and then the server, in addition to verifying the hash with its ... number' and grants the client access. ... The vulnerability in this protocol is that it allows a replay attack if ... simply storing the 'last used timestamp' and then, ...
    (sci.crypt)