请问：这个触发器怎么插入了所有的数据，我怎么能让它插入我想插入的那条数据！！谢谢了

[lanfanghelanfanghe]

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER TRIGGER PDM_dept_insert ON [dbo].[PDM_dept]
FOR INSERT
AS
declare @name1 varchar(50)
select @name1 = rtrim(ltrim(name)) from cerp_frame.dbo.test where flag = 1;

declare @mytime varchar(50)

set @mytime = substring(convert(varchar(10),getdate(),120),1,3)
exec('insert into [UFDATA_'+@name1+'_'+@mytime+'3'+'].dbo.department(cDepCode,cDepName)
select dept_code,dept_name from pdm.dbo.pdm_dept')
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

[pbsql]

exec('insert into [UFDATA_'+@name1+'_'+@mytime+'3'+'].dbo.department(cDepCode,cDepName)
select dept_code,dept_name from pdm.dbo.pdm_dept where 条件')

[zjcxc]

ALTER TRIGGER PDM_dept_insert ON [dbo].[PDM_dept]
FOR INSERT
AS
declare @name1 varchar(50)
select @name1 = rtrim(ltrim(name)) from cerp_frame.dbo.test where flag = 1;

declare @mytime varchar(50)

set @mytime = substring(convert(varchar(10),getdate(),120),1,3)
select dept_code,dept_name into #t from inserted
exec('insert into [UFDATA_'+@name1+'_'+@mytime+'3'+'].dbo.department(cDepCode,cDepName)
select * from #t')
GO