![SoftTree Technologies](templates/GreenTech/images/logo.gif) |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
Merge (Sql 2008) |
|
--cause I never remember the syntax
MERGE $OBJECT$ AS p
USING (SELECT
FROM ) AS s
ON
WHEN Matched THEN
UPDATE
SET $COLUMNS_V$= ,
WHEN NOT matched THEN
INSERT $COLUMNS$
VALUES s.;
|
|
Thu Jul 07, 2011 5:17 pm |
|
![](templates/GreenTech/images/spacer.gif) |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|