sql2005 触发器 新增数据到另一个表

alter trigger T_DataAddTOBuyRecord ON
Fl_Order_Success for insert
as
begin
 declare @OrderId varchar(50);declare @ProIds varchar(50);declare @UserId int;
 --set @OrderId=(select OrderId from Inserted);set @ProIds=(select ProIds from Inserted);
 select @OrderId=OrderId,@ProIds=ProIds,@UserId=UserId from Inserted;
 insert into Fl_BuyRecord (OrderId,ProId,UserId)
 select @OrderId,a,@UserId from dbo.f_split(@ProIds,',');
end