SQL Server Forums - A Trigger on a specific column update

SQL Server Forums - A Trigger on a specific column update

瀏覽:1383
日期:2025-06-10
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...看更多