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

1 vote175 views1 answer
Add 'CUSTOM_ELEMENTS_SCHEMA' to the '@NgModule.schemas' of this component to suppress this message
TypeScript
0 vote178 views1 answer
Cannot find module '@ngrx/effects' or its corresponding type declarations.ts(2307)
TypeScript
1 vote228 views1 answer
Cannot find module 'file-saver/FileSaver' or its corresponding type declarations.
TypeScript
2 votes155 views1 answer
Angular convert file to base64
TypeScript
2 votes197 views1 answer
Three dots icon flutter
TypeScript
0 vote159 views1 answer
Running same tests against different browsers
TypeScript
1 vote120 views1 answer
Typescript get unknown property
TypeScript
0 vote158 views1 answer
Servlets meaning
TypeScript
0 vote167 views1 answer
The migration '20200806160941_InitialMigration' has already been applied to the database. Revert it and try again. If the migration has been applied to other databases, consider reverting its changes using a new migration.
TypeScript
13 votes135 views7 answers
Lua print table contents
TypeScript