This post shows how to use a stored proc to insert an entity into your database and return the new identity.

This post shows you how to effectively use Case statements in SQL Server 2005.