Hi all,
i face some issue using SQL trigger. I have three sql tables, User, UserRole and
Role.
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
with MVC3.
Pls, help me !
Best Rgds,
df