Browse by Tags

All Tags » TVP (RSS)

SQL Server 2008 - The MERGE and TVP data access pattern with DataAdapters

The MERGE statement and Table Valued Parameters (TVPs) are two new features in SQL Server 2008 that make the process of doing DML (Data Manipulation i.e. INSERT, UPDATE and DELETE) on multiple rows very easy. This article shows how you can adapt Historically...

SQL Server 2008 - Handling deletes with MERGE

The MERGE statement is a new statement introduced in SQL Server 2008 that allows you to perform inserts, updates and deletes in one statement. You use a rowset as the source for the MERGE and as with all rowsets this can have any number of rows in it...

SQL Server 2008 - MERGE and optimistic concurrency

Most applications are written nowadays using optimistic concurrency. Locks aren’t placed on a piece of data for the duration of someone viewing that data in their application. Instead what you do is when someone wants to save the data you check to see...