Jeff's response about account numbers is the same as my reason for almost always using an IDENTITY as the primary (and clustered) key. As long as it's the IDENTITY column...

The UI is probably using bound controls (eg. a datagrid) to update a DataTable. It sounds as if it is then clearing the table and posting each remaining row to...

If your database originally resided on a different server (with a different collation), columns created would have used that default. Columns created after the migration would default to the collation...

If the stored procedure is returning the same results each time, it might be worth amending it to store those results in a table that can be referred to whenever...

Please also pick up on Phil's suggestion regarding the naming of defaults. This will save you so much pain when you put your code into source control and also when...

Re: On the other hand, as the father of a son on the autism spectrum, I'm very concerned for those with lower capabilities. How will they work for themselves (assuming they're...

You mention the impact on middle management and supervisors; I can imagine AI being able to schedule pointless meetings, but it will be some time before it can realistically take...

If you want to be stricter on what should be interpreted as numeric (and are using 2012 or later), you could change the WHERE clause to

where try_cast(TPN...

My two favourites were both from COBOL programs many years ago.

1. At the very top of the program, "This program operates on a finite state machine concept". That was the...

I mostly use PRINT and temp tables. One other thing I do in all multi-step stored procedures is to declare a variable called @ErrorLocation that is incremented before each step....

If GP does all its writes via stored procedures, you can deny write to his login and grant execute to the stored procedures.

The thing that disheartened me the most about the Sarbanes-Oxley act was that the very same companies that caused the crisis (eg. Enron's auditors) were able to make vast sums...

One advantage of casting 1 and 0 to bit is that some UIs will default to displaying these as True/False or ticked/unticked without any special coding.

There's a good reason most TV programmes are around the 50-55 minute mark (even on the BBC which doesn't stop for adverts every few minutes) - that's probably the length...