I need to have a stored procedure that will increment an integer value
in a control table column every time it is called and return that number to
the caller. The procedure will be called where columns name the procedure
to generate their default value. It will be used for by more columns than
simply the PK values. It would also be called by external programs, and
return a number to them as well. identity won't work because it isn't
unique across all tables, only works for the identity column, and requires a
row insert to trigger it. UniqueIdentifier ...