Update Tmp1 Set Maxno=(Select ISNULL(Max(Fhdno),0) From Tmp2)
Update Tmp1 Set Maxno=(Select ISNULL(Max(Fhdno),0) From Tmp2)
默认值,如果在insert into table (col1,col2,.....) 中指定就不会触发默认值。 update也一样!!
Update Tmp1 Set Maxno=(Select ISNULL(Max(Fhdno),0) From Tmp2)
可能isnull放在外面判断也行Update Tmp1 Set Maxno=ISNULL(Select Max(Fhdno) From Tmp2), 0)
Update Tmp1 Set Maxno=(Select Max(isnull(Fhdno,0)) From Tmp2) orUpdate Tmp1 Set Maxno=isnull((Select Max(Fhdno) From Tmp2),0) or Update Tmp1 Set Maxno=(Select isnull(Max(Fhdno),0) From Tmp2)
Update Tmp1 Set Maxno=(Select Max(isnull(Fhdno,0)) From Tmp2) orUpdate Tmp1 Set Maxno=isnull((Select Max(Fhdno) From Tmp2),0) or Update Tmp1 Set Maxno=(Select isnull(Max(Fhdno),0) From Tmp2)
test code 三种方法: Update Tmp1 Set Maxno=(Select Max(isnull(Fhdno,0)) From Tmp2) orUpdate Tmp1 Set Maxno=isnull((Select Max(Fhdno) From Tmp2),0) or Update Tmp1 Set Maxno=(Select isnull(Max(Fhdno),0) From Tmp2)
Update Tmp1 Set Maxno=(Select ISNULL(Max(Fhdno),0) From Tmp2)
update也一样!!
Update Tmp1 Set Maxno=(Select ISNULL(Max(Fhdno),0) From Tmp2)
Update Tmp1 Set Maxno=(Select Max(isnull(Fhdno,0)) From Tmp2) orUpdate Tmp1 Set Maxno=isnull((Select Max(Fhdno) From Tmp2),0) or
Update Tmp1 Set Maxno=(Select isnull(Max(Fhdno),0) From Tmp2)
Update Tmp1 Set Maxno=(Select Max(isnull(Fhdno,0)) From Tmp2) orUpdate Tmp1 Set Maxno=isnull((Select Max(Fhdno) From Tmp2),0) or
Update Tmp1 Set Maxno=(Select isnull(Max(Fhdno),0) From Tmp2)
三种方法:
Update Tmp1 Set Maxno=(Select Max(isnull(Fhdno,0)) From Tmp2) orUpdate Tmp1 Set Maxno=isnull((Select Max(Fhdno) From Tmp2),0) or
Update Tmp1 Set Maxno=(Select isnull(Max(Fhdno),0) From Tmp2)
Update Tmp1 Set Maxno=(Select ISNULL(Max(Fhdno),0) From Tmp2)