Archive for the ‘SQL’ Category

Using SCOPE_IDENTITY() with ObjectDataSource

ASP.NET, SQL 25.4.2009 No Comments

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 the identity seed…

Read More

SQL Delete Duplicate Records

SQL 14.3.2009 No Comments

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.

Read More

Row handle referred to a deleted row or a row marked for deletion

ASP, SQL 11.3.2009 No Comments

As I was maintaining some old ASP code for a client, we ran across the error below while migrating to a new site

Read More