Insert if not exists sql

If not exists insert sql

IF NOT EXISTS (SELECT * FROM EmailsRecebidos 
                   WHERE De = @_DE
                   AND Assunto = @_ASSUNTO
                   AND Data = @_DATA)
   BEGIN
       INSERT INTO EmailsRecebidos (De, Assunto, Data)
       VALUES (@_DE, @_ASSUNTO, @_DATA)
   END

Source: stackoverflow.com

Insert if not exists sql

INSERT INTO #table1 (Id, guidd, TimeAdded, ExtraData)
SELECT Id, guidd, TimeAdded, ExtraData
FROM #table2
WHERE NOT EXISTS (Select Id, guidd From #table1 WHERE #table1.id = #table2.id)
-----------------------------------
MERGE #table1 as [Target]
USING  (select Id, guidd, TimeAdded, ExtraData from #table2) as [Source]
(id, guidd, TimeAdded, ExtraData)
    on [Target].id =[Source].id
WHEN NOT MATCHED THEN
    INSERT (id, guidd, TimeAdded, ExtraData)
    VALUES ([Source].id, [Source].guidd, [Source].TimeAdded, [Source].ExtraData);
------------------------------
INSERT INTO #table1 (id, guidd, TimeAdded, ExtraData)
SELECT id, guidd, TimeAdded, ExtraData from #table2
EXCEPT
SELECT id, guidd, TimeAdded, ExtraData from #table1
------------------------------
INSERT INTO #table1 (id, guidd, TimeAdded, ExtraData)
SELECT #table2.id, #table2.guidd, #table2.TimeAdded, #table2.ExtraData
FROM #table2
LEFT JOIN #table1 on #table1.id = #table2.id
WHERE #table1.id is null

Source: stackoverflow.com

Similar codes

0 vote292 views1 answer
Why can't define generic function in tsx file
TypeScript
3 votes362 views3 answers
Get first day of month javascript moment
TypeScript
0 vote261 views1 answer
How to print certain elements of an array
TypeScript
0 vote279 views1 answer
Coding and testing is done in following manner
TypeScript
0 vote290 views1 answer
INTENT
TypeScript
0 vote303 views2 answers
Preventing letters from being placed in an input ts
TypeScript
0 vote306 views2 answers
Https://duckduckgo.com/?t=avast Ariana Grande (@arianagrande) • Instagram photos and videoswww.instagram.com › arianagrande 203.2m Followers, 686 Following, 4664 Posts - See Instagram photos and videos from Ariana Grande (@arianagrande)
TypeScript
11 votes293 views1 answer
Eliminate dots li
TypeScript
7 votes245 views5 answers
Firebase: Firebase App named '[DEFAULT]' already exists (app/duplicate-app).
TypeScript
2 votes290 views2 answers
Nodejs aws s3 upload
TypeScript