要点小毛病 求指点
create trigger tri_tb_dataplat_update

on tb_dataplat
for insert
as

declare @ID int
select @ID= DataID from tb_dataplat
insert into PP_CraftData（PP_CraftData_DataPlatID）values（@ID


两个表名（tri_tb_dataplat PP_CraftData） 字段名 DataPlatID DataID


哪错了 求指点
快呀 select as
[解决办法]

create trigger tri_tb_dataplat_update 
on tb_dataplat
for insert 
as
begin
insert into PP_CraftData (PP_CraftData_DataPlatID)
select DataID from inserted
end

[解决办法]

create trigger tri_tb_dataplat_update 
on tb_dataplat
for insert 
as
begin
insert into PP_CraftData (DataPlatID) --PP_CraftData_DataPlatID，有这个字段吗？
select DataID from inserted
end

[解决办法]
从语法看没什么问题,改为如下试试,确认相关的表和字段是否存在.

create trigger tri_tb_dataplat_update
on tb_dataplat for insert 
as
begin
 declare @ID int

 select @ID=DataID from tb_dataplat
 
 insert into PP_CraftData(PP_CraftData_DataPlatID) values(@ID)
end

[解决办法]

create trigger tri_tb_dataplat_update 
on tb_dataplat
for insert 
as
BEGIN
insert into PP_CraftData
(
PP_CraftData_DataPlatID
)
SELECT DataID
FROM INSERTED--楼主应该直接从INSERTED表中取ID值
END