插入唯一表示GUID

insert into M_ProductInfo select NEWID(),a.AnimalName+'-'+p.ProductName,null,cast(a.AnimalCode as varchar(20))+'-'+cast(p.ProductCode as varchar(20)),null,a.AnimalName+'-'+p.ProductName,0,0,null,GETDATE()

from M_AnimalInfo a join M_ProductInfo2 p on  1=1