假设要插入数据的数据表结构如下
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));
分别返回对应插入的数据的id,和受影响的行