Prevent to create SQL duplicates and prevent to stop execution. ALTER TABLE [SL_h].[dbo].[section_material_revenue] ADD CONSTRAINT date_sections_material UNIQUE([dates], [sections],[materials]) WITH (IGNORE_DUP_KEY = ON)

https://eitanblumin.com/2018/10/28/the-ignore_dup_key-option-in-primary-keys-and-unique-indexes/

BEGIN IF NOT EXISTS (SELECT * FROM [SL].[dbo].[av21_kode_for_style] WHERE [av21_code] = 'Z-BKSEH035x') BEGIN insert into [SL].[dbo].[av21_kode_for_style]( [av21_code])values('Z-BKSEH035x') END END 08.10.21

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024