i face some issue using SQL trigger. I have three sql tables, User, UserRole and
User : UserID,UserName,Comment
UserRole : UserRoleID,UserID,RoleID
Role : RoleID, RoleName, Comment
I had UserID and RoleID when row had been inserted in User table.
how do i create trigger to save automatically in UserRole table.
i am totally newbie in trigger. By the way, i am using Linq to SQL class
Pls, help me !