sql2000判断语句怎么写啊。
IF SELECT MAX(A.CBYF) AS CBYF FROM T_CBJLB A >SELECT MAX(A.CBYF) AS CBYF FROM T_YSFJLB A --判断当T_CBJLB的月份大于T_YSFJLB 时
begin
这里是要执行的语句
end
IF SELECT MAX(A.CBYF) AS CBYF FROM T_CBJLB A >SELECT MAX(A.CBYF) AS CBYF FROM T_YSFJLB A --判断当T_CBJLB的月份大于T_YSFJLB 时
begin
这里是要执行的语句
end
begin
...
END
IF (SELECT MAX(A.CBYF) AS CBYF FROM T_CBJLB A )>(SELECT MAX(A.CBYF) AS CBYF FROM T_YSFJLB A)
--判断当T_CBJLB的月份大于T_YSFJLB 时
begin
这里是要执行的语句
end
select @a=MAX(A.CBYF) FROM T_CBJLB
SELECT @b=MAX(A.CBYF) FROM T_YSFJLB
if @a>@b
begin
.....
end