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 vote197 views1 answer
Rails flags for tests assets and helpers
TypeScript
-1 vote211 views3 answers
Merge two arrays of objects lodash
TypeScript
0 vote202 views1 answer
Get list of property values from list of objects swift
TypeScript
0 vote257 views1 answer
Sort a list of ints python in descending order
TypeScript
0 vote201 views1 answer
Google sheets script save A RANGE to csv
TypeScript
0 vote184 views1 answer
InsertSheet() at the beginning of active sheets google script
TypeScript
0 vote203 views2 answers
Rails precompile assets in a directory
TypeScript
2 votes198 views1 answer
Jquery selector attribute value starts with
TypeScript
1 vote244 views1 answer
Passing variable data to laravel component
TypeScript
38 votes240 views2 answers
\Activate.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170
TypeScript