两个表互相插入数据
insert into Td_safe_InsureParas
(
InsureTypeID,
CityID,
CarTypeID,
CarSeatTypeID,
Item1Value,
Item2Value,
Item3Value,
Item4Value,
Item5Value,
Item6Value,
ResultValue
)
select
InsureTypeID,
CityID,
CarTypeID,
CarSeatTypeID,
Item1Value,
Item2Value,
Item3Value,
Item4Value,
Item5Value,
Item6Value,
ResultValue
from Td_safe_InsureParas where 1=1 and insuretypeid=221 and cityid=1
(
InsureTypeID,
CityID,
CarTypeID,
CarSeatTypeID,
Item1Value,
Item2Value,
Item3Value,
Item4Value,
Item5Value,
Item6Value,
ResultValue
)
select
InsureTypeID,
CityID,
CarTypeID,
CarSeatTypeID,
Item1Value,
Item2Value,
Item3Value,
Item4Value,
Item5Value,
Item6Value,
ResultValue
from Td_safe_InsureParas where 1=1 and insuretypeid=221 and cityid=1