 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
judahr
Joined: 09 Mar 2007
Posts: 320
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 |
  |
 |
|
|
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
|
|
|
