楼上正解 if exist(select * from .....)
补充2个
if(select count(*) from TABLENAME)>0
begin
print 'exist data'
end
else
begin
print 'no data'
ENDif(select top 1 * from TABLENAME) is null
begin
print 'no data'
end
else
begin
print 'exist data'
END
补充2个
if(select count(*) from TABLENAME)>0
begin
print 'exist data'
end
else
begin
print 'no data'
ENDif(select top 1 * from TABLENAME) is null
begin
print 'no data'
end
else
begin
print 'exist data'
END
select top 1 * from tablename 第一笔有数据就表示有数据!!
补充2个
if(select count(*) from TABLENAME)>0
begin
print 'exist data'
end
else
begin
print 'no data'
ENDif(select top 1 * from TABLENAME) is null
begin
print 'no data'
end
else
begin
print 'exist data'
END
顶
http://www.lyyywx.com.cn
http://www.bdgxqsq.com.cn