THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Denis Gobo

SQL Server 2008 (Katmai) Cannot Be Installed On A PC With SQL Server 2000 On It

I tried installing the SQL Server 2008 – June CTP on one of my machines which had SQL Server 2000 installed; it does not let you do that. I guess this is the time to uninstall SQL Server 2000. That is just what I did.

The first thing I noticed is that MERGE statement is back. IIRC the MERGE statement was also in SQL Server 2005 Beta2 but got pull out of the RTM

Here is a small example of using MERGE from the Katmai Books On Line

MERGE FactBuyingHabits AS fbh

USING (SELECT CustomerID, ProductID, PurchaseDate FROM PurchaseRecords) AS src

ON (fbh.ProductID = src.ProductID AND fbh.CustomerID = src.CustomerID)

WHEN MATCHED THEN

    UPDATE SET fbh.LastPurchaseDate = src.PurchaseDate

WHEN NOT MATCHED THEN

    INSERT (CustomerID, ProductID, LastPurchaseDate)

        VALUES (src.CustomerID, src.ProductID, src.PurchaseDate);

 

As you can see it does an UPSERT

Published Monday, June 04, 2007 3:26 PM by Denis Gobo

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Sumit said:

Hi Denis,

Just want to check if its possible to do UPSERT using SSIS 2005 on oracle database and what will be the best way to do so.?

My source is a Flat File and Target is an oracle Table.

Thanks

Sumit

August 29, 2007 2:34 AM

Leave a Comment

(required) 
(required) 
Submit

About Denis Gobo

I was born in Croatia in 1970, when I was one I moved to Amsterdam (and yes Ajax is THE team in Holland) and finally in 1993 I came to the US. I have lived in New York City for a bunch of years and currently live in Princeton, New Jersey with my wife and 3 kids. I work for Dow Jones as a Database architect in the indexes department, one drawback: since our data goes back all the way to May 1896 I cannot use smalldates ;-( I have been working with SQL server since version 6.5 and compared to all the other bloggers here I am a n00b. Some of you might know me from http://sqlservercode.blogspot.com/ or even from some of the newsgroups where I go by the name Denis the SQL Menace If you are a Tek-Tips user then you might know me by the name SQLDenis, I am one of the guys answering SQL Questions in the SQL Programming forum.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement