To solve difficult point of exists in practical use, specific applications of exists are studied. By actual case study analysis,how to design correctly SQL query statements with exists is summarized according to actual meaning in SQL Server 2005 environment.