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

Denis Gobo — Mon, 04 Jun 2007 18:26:00 GMT

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

Search results matching tags 'Katmai', 'SQL Server 2008', and 'UPSERT'

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