sql server返回插入数据表的id,和插入时间

假设要插入数据的数据表结构如下

id为自增列,

insert into UserInfo (username,userpass,email,RegTime) output inserted.ID values('AAAAA','AAAAA','AAAAA',getdate());
insert into UserInfo (username,userpass,email,RegTime) output inserted.ID values('AAAAA','AAAAA','AAAAA',CONVERT(datetime,'1980-12-17',120));