Create Trigger with condition in SQL Server

Hi Ruben12345,

I have created sample sql query which fill-full your requirement. Please refer the below sql query and modify as per your requirement.

SQL

CREATE TABLE [dbo].[mobile_manufactured](
	[Id] INT IDENTITY(1,1) NOT NULL,
	[manufactured] VARCHAR(50) NULL,
	[create_date] DATETIME NULL,
	[status] VARCHAR(10) NULL
);
--==================================================================== 
CREATE TABLE [dbo].[Mobile_data](
	[Id] INT IDENTITY(1,1) NOT NULL,
	[mid] INT NULL,
	[mname] VARCHAR(50) NULL,
	[imei] INT NULL,
	[manufactured] NVARCHAR(50) NULL,
	[price] INT NULL,
	[date] DATETIME NULL,
	[status] VARCHAR(20) NULL
);
--========================Record======================================
INSERT INTO Mobile_data VALUES(1,'M4 Aqua',78,'Sony Experia',6000000,'2017-06-10','True');
INSERT INTO Mobile_data VALUES(2,'Storm',80,' Blackberry',4000000,'2017-06-10','True');
INSERT INTO Mobile_data VALUES(3,'Galaxy',61,'Samsung mobile',5000000,'2017-06-10','True');
--========================TRIGGER=====================================
CREATE TRIGGER [dbo].[mobile_manufactured_INSERT]
       ON [dbo].[Mobile_data]
AFTER INSERT
AS
BEGIN
       SET NOCOUNT ON;
 
       DECLARE @manufactured  VARCHAR(20)
       DECLARE @create_date DATETIME
       DECLARE @Status VARCHAR(10)
 
       SELECT @manufactured = INSERTED.manufactured,@create_date=GETDATE(),@Status=INSERTED.status      
       FROM INSERTED
 
		IF NOT EXISTS(SELECT manufactured FROM mobile_manufactured WHERE manufactured=@manufactured ) 
		BEGIN
          INSERT INTO mobile_manufactured
         VALUES(@manufactured,@create_date,@Status);
       END
END
--=======================================================================

Screenshot