技术论坛

      [btsz100]:升迁到sql server 后，提示：int是不可以识别的函数名 SELECT ( year(':签订日期') & right('0' & month(':签订日期'),2) & right('0' & day(':签订日期'),2) & right(int(1000 + ("001" & A.ID)),3)) AS 合同编号 FROM (SELECT MAX(right(int (100000 + 合同登记表.合同编号),5)+1) AS ID FROM 合同登记表 WHERE 签订日期=':签订日期') AS A

——————————————————————————————————

      [lcqhy]:网络版的语句请参考：SELECT cast(year(':报价日期') as varchar(4))+cast(month(':报价日期') as varchar(2))+cast(day(':报价日期') as varchar(2))+right(str(1000 + (case when A.ID is null then '1' else A.ID end)),3) AS 单号 FROM (SELECT cast(right(max(报价单.报价单号),3) as int)+1 as ID FROM 报价单 where 报价日期=':报价日期') AS A

——————————————————————————————————

      [btsz100]:问题解决，谢谢指导