Browse by Tags

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 to save data using the DataAdpater you configure...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 06-18-2008
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. For an introduction see “MERGE an introduction”....

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 06-18-2008
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 whether someone else as changed it since the time...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 06-18-2008

Page 1 of 1 (3 items)

SQL Server Community Blogs