IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 13) BEGIN INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (13, N'AERONÁUTICO',0.0738,0,1); END IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 20) BEGIN INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (20, N'GRANIZO',0.0738,0,1); END IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 26) BEGIN INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (26, N'NÁUTICO',0.0738,0,1); END IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 50) BEGIN INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (50, N'RCF-DC',0.0738,1,1); END