IF COL_LENGTH( ‘Hmeshop_OrderItems’,‘AgentEarningsReward’) IS NULL begin alter table Hmeshop_OrderItems add AgentEarningsReward money null exec sp_addextendedproperty N’MS_Description’, N’总代收益 ‘, N’SCHEMA’, N’dbo’, N’table’, N’Hmeshop_OrderItems’, N’column’, N’AgentEarningsReward’ end
