---- APAGAR BASE DE DADOS TOTALMENTE ---- DELETE FROM tbArquivo_Documental DELETE FROM tbClientes DELETE FROM tbClientes_Apolices DELETE FROM tbClientes_Apolices_Actas DELETE FROM tbClientes_Apolices_Bem_Automovel DELETE FROM tbClientes_Apolices_Bem_Barco DELETE FROM tbClientes_Apolices_Bem_Imovel DELETE FROM tbClientes_Apolices_Bem_Links DELETE FROM tbClientes_Apolices_Bem_Moto DELETE FROM tbClientes_Apolices_Bem_Outro DELETE FROM tbClientes_Apolices_Bem_Pessoa DELETE FROM tbClientes_Apolices_Coberturas DELETE FROM tbClientes_Apolices_Comissoes DELETE FROM tbClientes_Apolices_Obs DELETE FROM tbClientes_Apolices_Permitions DELETE FROM tbClientes_Apolices_Recibos DELETE FROM tbClientes_Apolices_Recibos_Pagamentos DELETE FROM tbClientes_Apolices_Suspensoes DELETE FROM tbClientes_Permitions DELETE FROM tbClientes_Permitions_Inactivos DELETE FROM tbClientes_Sinistros DELETE FROM tbClientes_Sinistros_Coberturas DELETE FROM tbClientes_Sinistros_Controlo DELETE FROM tbClientes_Sinistros_Diario DELETE FROM tbClientes_Sinistros_Entidades DELETE FROM tbClientes_Sinistros_Entidades_Circuntancias DELETE FROM tbClientes_Sinistros_Obs DELETE FROM tbClientes_Sinistros_Permitions DELETE FROM tbColaboradores DELETE FROM tbColaboradores_Inactivos DELETE FROM tbColaboradores_Permitions DELETE FROM tbColaboradores_Permitions_Inactivos DELETE FROM tbComissionistas DELETE FROM tbComissionistas_PContas DELETE FROM tbComissionistas_PContas_Details DELETE FROM tbContactos DELETE FROM tbContactos_Comunicacoes DELETE FROM tbContactos_Comunicacoes_Inactivos DELETE FROM tbContactos_ContasCorrentes DELETE FROM tbContactos_ContasCorrentes_Inactivos DELETE FROM tbContactos_Emails DELETE FROM tbContactos_Emails_Inactivos DELETE FROM tbContactos_Fotos DELETE FROM tbContactos_Fotos_Inactivos DELETE FROM tbContactos_Inactivos DELETE FROM tbContactos_Institucionais DELETE FROM tbContactos_Institucionais_Inactivos DELETE FROM tbContactos_Links DELETE FROM tbContactos_Links_Inactivos DELETE FROM tbContactos_Moradas DELETE FROM tbContactos_Moradas_Inactivos DELETE FROM tbContactos_Nibs DELETE FROM tbContactos_Nibs_Inactivos DELETE FROM tbContactos_Obs DELETE FROM tbContactos_Obs_Inactivos DELETE FROM tbContactos_Singulares DELETE FROM tbContactos_Singulares_Inactivos DELETE FROM tbContactos_Telefones DELETE FROM tbContactos_Telefones_Inactivos DELETE FROM tbContactos_Tipos_Links DELETE FROM tbContactos_Tipos_Links_Inactivos DELETE FROM tbContactos_Totais_Acumulados DELETE FROM tbContactos_Totais_Acumulados_Inactivos DELETE FROM tbMailling DELETE FROM tbMailling_Details DELETE FROM tbOutros_Contactos DELETE FROM tbOutros_Contactos_Inactivos DELETE FROM tbOutros_Contactos_Permitions DELETE FROM tbOutros_Contactos_Permitions_Inactivos DELETE FROM tbOutsourcing DELETE FROM tbOutsourcing_Inactivos DELETE FROM tbOutsourcing_Permitions DELETE FROM tbOutsourcing_Permitions_Inactivos DELETE FROM tbPessoais_Contactos DELETE FROM tbPessoais_Contactos_Inactivos DELETE FROM tbPessoais_Contactos_Permitions DELETE FROM tbPessoais_Contactos_Permitions_Inactivos DELETE FROM tbSeguradoras DELETE FROM tbSeguradoras_Caixa DELETE FROM tbSeguradoras_Inactivos DELETE FROM tbSeguradoras_P_Contas DELETE FROM tbSeguradoras_P_Contas_Details DELETE FROM tbSeguradoras_Permitions DELETE FROM tbSeguradoras_Permitions_Inactivos DELETE FROM tbSeguradoras_Produtos DELETE FROM tbSeguradoras_Ramos DELETE FROM tbUsers DELETE FROM tbGroups_Users_Links DELETE FROM tbFechos UPDATE tbContadores SET contacto_id = 2, no_cliente = 1, proposta_no = 1, mailling_no = 1, sinistro_no = 1, sinistro_ano = YEAR(GETDATE()), recibo_no = 1 INSERT INTO tbContactos (contacto_id, nome_union, genero_id, created_by, created_date, modified_by, modified_date, chave) VALUES (1, 'Sistemas Criticos, Lda', 2, 'SYSTEM', GETDATE(), 'SYSTEM', GETDATE(), 'Sistemas Criticos') INSERT INTO tbContactos_Institucionais (contacto_id) VALUES (1) INSERT INTO tbContactos_Tipos_Links (contacto_id, contacto_tipo_id) VALUES (1, 3) INSERT INTO tbOutros_Contactos (contacto_id) VALUES (1) INSERT INTO tbOutros_Contactos_Permitions (contacto_id, group_code, user_code) VALUES (1,'$00011111$00041110$00031100$00021000$00071100','') INSERT INTO tbUsers (contacto_id, code, descrit) VALUES (1,'&0001','sa') DECLARE @LAST_ID int SET @LAST_ID = (SELECT @@IDENTITY) INSERT INTO tbGroups_Users_Links ([user_id], group_id, predef) VALUES (@LAST_ID, 1,1)