SQL 2005升到SQL 2008算法居然都变了?真要命.莫非又是微软漏洞?
李迎春82 2013-10-07 05:17:55 create table trx (code int,quantity int)
go
create function trxCodeNew() returns int as
begin
return(isnull((select MAX(code)+1 from trx),1))
end
go
insert into trx
select dbo.trxCodeNew(),10
union all
select dbo.trxCodeNew(),15
union all
select dbo.trxCodeNew(),18
SQL 2005 结果
1,10
1,15
1,18
SQL 2008 结果
1,10
2,15
3,18
2008要如何实现2005的算法?