Yes, COLUMN ORDER DOES MATTER in some data layer tier applications. They look to the first column being the primary key and if an ID column was added at the...
Automate this stuff.... why manually look... but do not have you database server watch itself. That is like an internal investigation. Not much checks and balances there.
hmmm... I personally hate table variables because they cause the disk queue length (I/O) and CPU to shoot through the roof. They only work on simple small systems with...