Re: convert hex string to hex

From: Joseph (joseph_at_bluefield.com.hk)
Date: 08/20/04 

Date: Fri, 20 Aug 2004 14:57:58 +0800

Thanks. What I want is to check whether a record has been modified by
comparing the timestamp field in the record.

I just convert the binary array to base-64 int in my C# program and pass the
int to the stored procedure. Then cast the int to binary/timestamp type and
compare with the timestamp field in the record.

Joseph

"Tamas Bojcan - bojci" <bojcan@freemail.hu> wrote in message
news:%23R77ElchEHA.2916@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> What does it mean "hex number"? Do you mean binary type?
>
> Convert hex string to int:
> http://www.sqlservercentral.com/scripts/contributions/94.asp and from
int
> type you can convert easily into other types.
>
>
> "Joseph" <joseph@bluefield.com.hk> wrote in message
> news:enYZcQchEHA.3536@TK2MSFTNGP12.phx.gbl...
> > In SQL, how can I convert a hex string like '0xff' to a hex number 0xff?
> >
> > thanks,
> > Joseph
> >
> >
>
>

Relevant Pages

  • Re: speed of generic code in Ada (vs Java)
    ... Is the situation similar with generics in Ada, GNAT, ... autoboxing that slows things down - java has both an int as a primitve ... which is a bit like comparing Ada arrays with Ada Containers. ...
    (comp.lang.ada)
  • [PATCH 5/5] remove HAVE_ARCH_CMPXCHG
    ... * indicated by comparing RETURN with OLD. ... static inline unsigned long __cmpxchg(volatile void *ptr, unsigned long old, ... cmpxchg(volatile int *p, int old, int new) ...
    (Linux-Kernel)
  • Need faster bitmap compare method
    ... region size im scanning is 128x96 on a 1024x768 bitmap. ... int curx = 0; ... int cury = 0; ... //This code actually does the comparing ...
    (microsoft.public.dotnet.framework.drawing)
  • Re: Comparing singed to unsinged warning
    ... comparing an unsinged value to a singed value? ... the warning *could* be useful. ... This makes disabling it undesirable. ... int CmpSU ...
    (comp.lang.c)
  • Re: warning - comparing a signed value to an unsinged value
    ... > What do you think is the best way to handle a compiler warning ... > about comparing an unsigned value to a signed value? ... > go undetected due to the cast. ... it is obviously larger than the int. ...
    (comp.lang.c)