In today's column we'll demonstrate how and when to use the new TSQL MERGE statement and how this can be a helpful addition to your toolbox.
Latest Database Articles - Page 2
Learn how to define policies and use them to better manage your SQL Server 2008 instances.
This article was written mainly for developers who use Firebird Embedded SQL Server in .Net framework applications and want to speed up or optimize DB queries. We will describe how to create your own native Firebird extension and show some approaches how to use it in managed code applications.
Explore a CRecordSet-like interface to a SQLite database table.
By Dee Quang - Ever get confused by or dislike using the SQL Server Integration Services deployment wizard? Learn how to manually deploy the packages to SQL Server 2005 and configure the packages in a multitude of ways as well.
Why get bogged down in the quicksand of the Oracle Call Interface (OCI) when you can get the same service with less code and fewer headaches with Vincent Rogier's OCILIB?
Latest Developer VideosMore...
Latest CodeGuru Developer Columns
It's essential to know the differences in these libraries and use them correctly. This brief tutorial will guide you.
Learn how to pass off the delegation of an operation to a different class.
The BitVector structure has many useful properties, and knowing how to make proper use of memory will always improve the performance of your applications.
Here are some guidelines to make implementing load testing easier and more likely to be well received by your team.