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 SQL Server Articles - Page 2
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.
Sometimes when you have all kinds of data what you really need is XML. LINQ to XML let's you employ functional construction to convert your data into XML.
Elevate your SQL game (a little bit) with CROSS APPLY and OUTER APPLY.
LINQ to SQL eliminates SQL Injection Attacks and is easier to use than straight SQL to boot.
Learn how to make Visual Studio Team Suite Database Edition part of your development process.
Latest Developer VideosMore...
Latest CodeGuru Developer Columns
The Transactional File System (TxF), which allows access to an NTFS file system to be conducted in a transacted manner through extensions to the Windows SDK API. MFC 10, has been extended to support TxF and related technologies. This support allows existing MFC applications to be easily extended to support kernel transactions.
Adding extra fields to an ASP.NET membership set-up doesn't have to be difficult, especially if there is only a small amount of data.
Hannes du Preez explains what delegates are and how to use them to call managed and unmanaged code in VB.NET.
This article introduces you to Big Data, Apache Hadoop and MapReduce jobs. We will also learn how to create MapReduce jobs using C#.