I have table dbo.Manu_angle , dbo.Manufacturer_update and dbo.Manufa_info
Table dbo.Manufa_info have Primary key 'emails' and 'Password'
Table dbo.Manu_angle have foreign key 'emails' and 'Password' table dbo.Manu_angle
-------------------------------------------
| ID | emails | Password | Price |
-------------------------------------------
| 1 |A@A.com | 101 | 12 |
-------------------------------------------
table dbo.Manufacturer_update
---------------
| ID | Users |
---------------
table dbo.Manufa_info
----------------------------------------------------
| ID | emails | Password | Manufact_name |
---------------------------------------------------
|1 |A@A.com | 101 | Myke |
---------------------------------------------------
i want to create a trigger in table dbo.Manu_angle such that any user inserted / updated his information, it takes emails and Password from dbo.Manu_angle compare it with emails and Password of table dbo.Manufa_info and extract Manufact_name and after that insert Manufact_name into table dbo.Manufacturer_update in user column. Firstly my trigger code was as:-
create trigger tr_Manu_insert2
on Manu_angle
for insert
AS
Begin
declare @emailinsert varchar
declare @emails varchar
declare @Passwords varchar
declare @selects varchar
select @emails = Manuf_Emails from inserted
select @Passwords= Manuf_password from inserted
select @selects=(select Manufact_name from Manufa_info where Manu_Email=@emails AND Manu_Password=@Passwords)
insert into Manufacturer_update(Users) values (@emails)
END
Which insert Null value in table dbo.Manufacturer_update in user column and by rechake my code i found error in @emails which gives value 's' which is unexpected value.