if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[A]
GOCREATE TABLE [dbo].[A] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[c1] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[c2] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO------------------------
create trigger trigger_name on [dbo].[A]
for insert select id from inserted----------------------------------
insert a(typename,table2id) select 'aaaa','bb'---------试试上面的例子
drop table [dbo].[A]
GOCREATE TABLE [dbo].[A] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[c1] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[c2] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO------------------------
create trigger trigger_name on [dbo].[A]
for insert select id from inserted----------------------------------
insert a(typename,table2id) select 'aaaa','bb'---------试试上面的例子
drop table [dbo].[A]
GOCREATE TABLE [dbo].[A] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[c1] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[c2] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO------------------------
create trigger trigger_name on [dbo].[A]
for insert select id from inserted----------------------------------
insert a(c1,c2) select 'aaaa','bb'---------试试上面的例子