Using SCOPE_IDENTITY() with ObjectDataSource
Microsoft’s introduction of the ObjectDatasource in ASP.NET 2.0 was a great addition. It saves developers alot of time once they are familar with the controls. The problem is that what seemed like simple tasks when coding everything by hand sometimes became more difficult to figure out. For example, how do I return [...]
SQL Delete Duplicate Records
I ran into the issue today with a client where their data was messed up with duplicate data (but different identity seeds) The following code only works when there is an identity seed. Remember to inlcude all the columns that would indicate a duplicate in the GROUP BY.
Row handle referred to a deleted row or a row marked for deletion
As I was maintaining some old ASP code for a client, we ran across the error below while migrating to a new site