Re: stored procs

On 09/30/11 1:23 AM, John R Pierce wrote:
> convert the fields to bigint which are 64 bit and not likely to wrap
> around any time in this century

indeed, this is as simple as ...

     alter table tblname alter column id type bigint;

of course, you'll need to alter all the FK fields that refer to it too,
and I don't know if that entangles this.


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast