1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
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
|
