SQL Server Forums - A Trigger on a specific column update

the problem with your code is you assume inserted will contain only a single record but its not always the case. so make it like below Create trigger AddCollegeOfToCollDescOnInsert on Program_Map_full for insert as begin update p set coll_desc='College of

www.sqlteam.com