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.
SELECT, INSERT, UPDATE with the SQL MERGE Statement
Published 01/19/2010
Latest SQL Server Articles - Page 2
Writing UDFs for Firebird Embedded SQL Server
Published 11/17/2009
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.
Converting Data to XML with LINQ to XML
Published 10/05/2009
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.
Using T-SQL CROSS APPLY and OUTER APPLY
Published 01/26/2009
Elevate your SQL game (a little bit) with CROSS APPLY and OUTER APPLY.
OP-ED: Why LINQ to SQL is a Better Option than Straight SQL
Published 08/15/2008
LINQ to SQL eliminates SQL Injection Attacks and is easier to use than straight SQL to boot.
Beginner's Guide to SQL Server Database Development with VSTS Database Edition
Published 06/10/2008
Learn how to make Visual Studio Team Suite Database Edition part of your development process.
Latest Developer Videos
More...
Latest CodeGuru Developer Columns
MFC Integration with the Windows Transactional File System (TxF)
Published 04/18/2011
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.
.NET Framework: Collections and Generics
Published 06/23/2011
The original release of the .NET Framework included collections as .NET was introduced to the Microsoft programming world. The .NET Framework 2.0 introduced generics to complement the System.Collections namespace and provide a more efficient and well performing option. Read on to learn more...
Disabling Titlebar Buttons with VB.NET
Published 06/14/2013
Hannes du Preez shows you how to disable titlebar buttons and menus in your programs temporarily.
WebSockets Meets Security
Published 06/17/2013
WebSockets are intended to build bi-directional connections between a web browser and a server. This must be done in a safe way. In addition, the WebSockets have a huge disadvantage (to say it politely). Read on to learn more.
