sql语句执行插入后返回ID

insert into table1(aaa,bbb) values('aaa','bbb') select @@identity