SQLServer2005的Output子句获取刚插入的ID值
语法很简单，比如
declare @
t
table (
id
uniqueidentifier
default
newid
(),
name
varchar (
100 ))
insert into @ t ( name ) output inserted . id select 'jinjazz' union select 'sqlserver'
/*输出类似
3880DB77-5ADF-472D-A68D-7518DD76F3B8
F478A3F5-A501-404E-A328-372EEC26279D
*/
insert into @ t ( name ) output inserted . id select 'jinjazz' union select 'sqlserver'
/*输出类似
3880DB77-5ADF-472D-A68D-7518DD76F3B8
F478A3F5-A501-404E-A328-372EEC26279D
*/