下面的DML语句,在高版本的SQL Server中执行是没有问题的,但是2000不能用
Insert into TP_Weight
(ID,CreateTime,Weight,S_NO,TP_TYPE,Creator,TP_NO,Stateop,SortNumber,HUAYSBH)
values
(
(select isnull(max(ID),0)+1 from TP_Weight),
GetDate(),
0.0485,
'14931648676',
'CLY',
'tester',
'#1天平',
(select isnull(max(SortNumber),0)+1 from TP_Weight where S_NO='14931648676' and Huaysbh='0' and TP_Type='CLY'),
'0'
);
将上面的语句改成这样,SQLSever 2000及以上都可以使用了
Insert into TP_Weight
(ID,CreateTime,Weight,S_NO,TP_TYPE,Creator,TP_NO,Stateop,SortNumber,HUAYSBH)
select isnull(max(ID),0)+1,
GetDate(),
0.0485,
'14931648676',
'CLY',
'tester',
'#1天平',
1 ,
(select isnull(max(SortNumber),0)+1 from TP_WEIGHT where S_NO='14931648676' and Huaysbh='0' and TP_Type='CLY'),
'0'
from TP_Weight