create table ta(orderID int identity(1,1),userid int,orderdate datetime)
create trigger ta_tr on ta
for insert
as
select orderID from inserted
就这样就行了,显示插入的orderID
--测试
insert into ta select 1, '2006-11-26 10:50:39.623'
union all select 4,'2006-11-26 10:51:22.623'
orderID
-----------
1
2