如何检查sql server 2008中的空表？ [英] how to check empty table in sql server 2008?

问题描述

CREATE procedure [dbo].[ReportByDate]  
(  
 @StartDate DATE,  
 @EndDate DATE,
 @Email nvarchar(40)
 )  
as  
begin  
If exists(select 1 from tblWorkExpDetails)  
begin
select  
pd.FirstName,  
pd.LastName,  
pd.Mobile,  
pd.Email,  
pd.Sources,  
ed.XthPercentage,  
ed.XIIthPercentage,  
wed.CurrentSalary,  
wed.TotalExperience 
from  
tblPersonalDetails pd   
Inner Join tblEducationalDetails ed on pd.Email=ed.Email  
Inner Join tblWorkExpDetails wed on pd.Email=wed.Email  
where pd.JoinDate Between @StartDate and @EndDate  
end
else if exists(select 1 from tblFresherDetails)   
select   
pd.FirstName,  
pd.LastName,  
pd.Mobile,  
pd.Email,  
pd.Sources,  
ed.XthPercentage,  
ed.XIIthPercentage,  
fd.Typing   
from  

tblPersonalDetails pd   
Inner Join tblEducationalDetails ed on pd.Email=ed.Email  
Inner Join tblFresherDetails fd on pd.Email=fd.Email  
where pd.JoinDate Between @StartDate and @EndDate
end;    

- 此查询仅返回tblWorkExpDetails表中存在的那些记录。帮助我！

--This query only returns those records which are present in tblWorkExpDetails table. Help me !

推荐答案

使用此查询查找数据库中包含空行的表：

< br $>

Use this query to find the Table with Empty Rows in the Database:

SELECT sc.name +'.'+ ta.name TableName
,SUM(pa.rows) RowCnt
FROM sys.tables ta
INNER JOIN sys.partitions pa
ON pa.OBJECT_ID = ta.OBJECT_ID
INNER JOIN sys.schemas sc
ON ta.schema_id = sc.schema_id
WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)
GROUP BY sc.name,ta.name
having SUM(pa.rows)=0
ORDER BY SUM(pa.rows) DESC

这篇关于如何检查sql server 2008中的空表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！