Till now this is my solution (partial code):

IF (@error = 0)

BEGIN

-- elimino i faldoni associati al sito

UPDATE AF_Faldone SET Status = 1 WHERE (IDSito = @idSito)

SET @error = @@ERROR

END

IF (@error...

Yes, I knows the trigger solution but I would prefer something else if it exists, otherwise goes on trigger...

Tnx

Till now (and I think also in the future) performance is not so important, but if you have another solution, faster, it's welcome.

Can you explain me where's performance problems in...

Mmm, if I'll have to put this constraint I'll remember of your solution... Till now the constraint is not important. Tnx

>>>>have to check @@ERROR

I know, i'm using always this.

Tnx to all.

Tnx to all!!

I'll never reach it without you... Probably only the single trigger, but the trigger for more than one insert is... awesome!! Tnx again.

Just last two questions:

1) I'll put...

I think the solution of James is almost the right one...

Some explanation:

"if exists (select 1 from inserted where val_numspedizione = 0)"

is to prevent the trigger executio if the insert was...

Ok, below is the script for the table...

The field of interest are:

ID_Spedizione

AA_Anno

Val_NumSpedizione

The last is the number to create...

Tnx

----------------------------------------

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_GSP_Spedizione_GSP_Spedizione1]') and OBJECTPROPERTY(id, N'IsForeignKey')...