I have a base table used everywhere called
Customers. Of course, its unlikely that table will ever grow past
int size, but it is keyed on a
I don't believe that I can change the type of this identity column to
int. But what is your advice for building stored procedures, table type variables etc that refer or carry data for this column? Should I perpetuate
bigint in these routines? Will they run leaner if I use
int, leaving it to the engine to run implicit conversions?