Your syntax is all over the place
INSERT INTO [AffecAnalytique].[dbo].[C9_V]
([C9],[V],[OID],[USERMODIF])
SELECT [C9],[V],[OID]
FROM [AffecAnalytique].[dbo].[C9_V] WHERE [OID]='CEC4F038E3954AC79DBF7EC38B02171F'
, 'AHE'
Try
INSERT INTO [AffecAnalytique].[dbo].[C9_V]([C9],[V],[OID],[USERMODIF]) SELECT [C9],[V],[OID],'AHE' FROM [AffecAnalytique].[dbo].[C9_V] WHERE [OID]='CEC4F038E3954AC79DBF7EC38B02171F'
although I doubt that is really what you want.
If you have defined the list of columns you want to add you just have to supply values for them. The column names do not need to be the same, but you do need to supply
all the values