SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table partsfeature
(
  PartId int,
  FeatureName varchar(300),
  FeatureValue varchar(300),
  TechnologyId int
);

INSERT INTO partsfeature(PartId,FeatureName,FeatureValue,TechnologyId)
VALUES(1211,'AC','5V',1),
(2421,'grail','51V',2),
(6211,'compress','33v',3)
3 rows affected

WITH CTE AS
(
  SELECT 3900 AS PartId, 'grail' AS FeatureName, '51V' AS FeatureValue
  UNION ALL
  SELECT 5442,'compress','30v'
  UNION ALL
  SELECT 7791,'AC','59V'
  UNION ALL
  SELECT 8321,'Angit','50V'
)
INSERT INTO partsfeature(PartId,FeatureName,FeatureValue,TechnologyId)
SELECT A.PartId, A.FeatureName, A.FeatureValue, B.TechnologyId
FROM CTE AS A INNER JOIN partsfeature AS B
  ON A.FeatureName = B.FeatureName;
3 rows affected

SELECT *
FROM partsfeature;


PartId
FeatureName
FeatureValue
TechnologyId


1211
AC
5V
1

2421
grail
51V
2

6211
compress
33v
3

3900
grail
51V
2

5442
compress
30v
3

7791
AC
59V
1

PartId	FeatureName	FeatureValue	TechnologyId
1211	AC	5V	1
2421	grail	51V	2
6211	compress	33v	3
3900	grail	51V	2
5442	compress	30v	3
7791	AC	59V	1