DECLARE @AdmDate datetime SELECT @AdmDate=max(AdmDate) FROM tbl_ConsumerList WHERE EmployeeID=45 --if可以直接判断 if (@AdmDate = null) select .....
DECLARE @AdmDate datetime SELECT @AdmDate=AdmDate FROM tbl_ConsumerList WHERE EmployeeID=45 And ORDER BY AdmDate ASC if @@rowcount>0 begin ......有值 end else begin ......无值 end
标准方法是使用EXISTS判断是否有指定条件并且AdmDate不是NULL的纪录
DECLARE @AdmDate datetime SELECT @AdmDate=AdmDate FROM tbl_ConsumerList WHERE EmployeeID=45 And ORDER BY AdmDate ASC if isnull(@AdmDate,0)<>0 begin ......有值 end else begin ......无值 end
SELECT @AdmDate=max(AdmDate) FROM tbl_ConsumerList WHERE EmployeeID=45 --if可以直接判断
if (@AdmDate = null)
select .....
SELECT @AdmDate=AdmDate FROM tbl_ConsumerList WHERE EmployeeID=45 And ORDER BY AdmDate ASC
if @@rowcount>0
begin
......有值
end
else
begin
......无值
end
SELECT @AdmDate=AdmDate FROM tbl_ConsumerList WHERE EmployeeID=45 And ORDER BY AdmDate ASC
if isnull(@AdmDate,0)<>0
begin
......有值
end
else
begin
......无值
end