Re: stored procedure to capture identity values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hassan (fatima_ja_at_hotmail.com)
Date: 08/01/04

  • Next message: David Portas: "Re: stored procedure to capture identity values" 
    Date: Sat, 31 Jul 2004 23:59:06 -0700

    Hmmm.. what about storage of numeric vs int ? Worth a thought.. but some of
    our tables are already in the second portion of my initial message.. Had to
    reseed and stuff..

    "David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
    news:j9OdnfHrfcmgEZHcRVn-ig@giganews.com...
    > Seems like a lot of trouble to little benefit. Why not just go through and
    > select the appropriate datatype for each IDENTITY so that there's no
    chance
    > of running out of values during the lifetime of the system. NUMERIC can go
    > up to 10^38. Surely that's enough for you?
    >
    > --
    > David Portas
    > SQL Server MVP
    > --
    >
    >

  • Next message: David Portas: "Re: stored procedure to capture identity values"

    Relevant Pages

    • Re: Linux 2.6.27.9
      ... static int smp_pSeries_cpu_bootable ... "HUAWEI MOBILE", ... "Mass Storage", ...
      (Linux-Kernel)
    • Re: one-liner for characater replacement
      ... declaration you can omit the type and it is assumed 'int', ... a qualifier e.g. 'const'. ... unspecified but fixed default-promoted arguments returning int'. ... (Qualification only makes sense for things in storage ...
      (comp.lang.fortran)
    • Re: Datetime or GPS format
      ... each row i save approx 1 TB of storage which is quite huge for me. ... Some day, trust me, you will end up with some int value which isn't a valid date. ... comparision only right ... ...
      (microsoft.public.sqlserver.programming)
    • Re: GCC bitfield packing
      ... The actual amount of storage taken us depends only upon the number of ... The size of the storage unit that those bits are stored ... depend upon the type of the bitfield declaration. ... _Bool, int, signed int, and unsigned int. ...
      (comp.std.c)
    • Re: Gameroom almost complete
      ... It was a lot of work and will hope to be worth ... pictures are of the storage bin I rented for 2 and half years. ... bins email me. ... all the planning in the world wont make a difference...Thanks for reading ...
      (rec.games.pinball)