Simple use of triggers (use a cursor to update multiple rows)

 

Create trigger [usageinsert] on [DBO]. [t_res_usage_info]
After insert // execute after insert
As
Begin
Declare every_use_cursor cursor local forward_only
Select res_typ from inserted // create a cursor
Declare @ myres_type_name varchar (20 );

Open every_use_cursor
Fetch next from every_use_cursor into @ myres_type_name

While @ fetch_status = 0 // judge the returned row
Begin

If @ myres_type_name is not null
Begin
If not exists (select res_type_name from t_res_type where res_type_name = @ myres_type_name)
Begin
Insert t_res_type (res_type_name, remark) values (@ myres_type_name ,'');
End;
End;

Fetch next from every_use_cursor into @ myres_type_name;
End;
Close every_use_cursor // close the cursor
Deallocate every_use_cursor // release the cursor
End;