INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0016050002', 'A', Null, 'TP7', Null, Null, Null, '3ª CONSERVATORIA DO REG.CIVIL DA COMARCA DE LUANDA',...

INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0016050002', 'A', Null, 'TP7', Null, Null, Null, '3ª CONSERVATORIA DO REG.CIVIL DA COMARCA DE LUANDA',...

How can I send the data sample?

Text file?

and please, forget the trigger: TRG_CONTRIBUINTES_TRILHA_ALTERACOES_INS

I deleted from my table.

That updates the entire table!

I have deleted my first trigger and created a new one based on the code changes you told me.

The trigger is now like:

USE [SGCTCentral]

GO

/****** Object: ...

I dont understand the code below:

update contribuintes

set

nif = d.nif,

...

Hi,

The table ddl is:

USE [SGCTCentral]

GO

/****** Object: Table [dbo].[CONTRIBUINTES] Script Date: 11/07/2012 11:46:02 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[CONTRIBUINTES](

[NIF] [varchar](20) NULL,

[FILIAL_NUMBER] [char](1) NULL,

[NIF_ANTIGO] [varchar](20)...

Sean Lange (10/30/2012)

---

I think this should do what you are looking for but it is untested because I don't have ddl to work with.

create trigger TRG_CONTRIBUINTES_VERIFCA_RF_E_NIF on contribuintes

for update

as begin

update...

like this:

update

contribuintes

set

nif = c.nif

from

contribuintes c

join

deleted d

on

d.nif_antigo = c.nif_antigo

where

c.numeroposto = 'Central'

The code:

Has a problem.

I want that...

I think that is what is needed but we have a problem:

I only want that the trigger acts if the column numeroposto new value is 'Central'. If it's not, it...

Hi,

What I'm trying to do is:

I have a table named "contribuintes" this table has several fields, including the fileds:

numeroposto, cod_rep_fiscal and NIF.

I want that, if an update takes place and...

Thank you for the reply.

Same problem.

Error bellow:

Msg 4104, Level 16, State 1, Procedure TRG_CONTRIBUINTES_VERIFCA_RF_E_NIF, Line 11

The multi-part identifier "deleted.NUMEROPOSTO" could not be bound.

Msg 4104, Level 16, State 1, Procedure TRG_CONTRIBUINTES_VERIFCA_RF_E_NIF,...

I have done it.

My proc is now as this:

USE [SGSC]

GO

/****** Object: StoredProcedure [dbo].[spSGCT_UPDATESINCRONISMO_SGCTLOCAIS] Script Date: 06/27/2012 16:13:12 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[spSGCT_UPDATESINCRONISMO_SGCTLOCAIS]

(@DATA1 AS...

The procedure is now like this:

USE [SGSC]

GO

/****** Object: StoredProcedure [dbo].[spSGCT_UPDATESINCRONISMO_SGCTLOCAIS] Script Date: 06/27/2012 14:33:55 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[spSGCT_UPDATESINCRONISMO_SGCTLOCAIS]

(@DATA1 AS varchar(50),@DATA2 AS varchar(50),@NOMEFICHEIRO...