Guest Columnist: Jason Rein

Jason Rein is a consultant with Oakwood Systems Group, Inc. in Nashville, TN. Jason has been working with SQL Server for 7 years and currently specializes in web-based applications.

   Items 1 to 1 of 1   

 

Tip: Testing for the Existence of Data

There are times when we need to know that rows of data that meet specific criteria exist in a table. There are 2 basic ways to find this information: COUNT() and EXISTS(). Here are some examples.   Read more...

By Jason Rein 2001/12/20 | Source: SQLServerCentral.com | Category: Performance Tuning

Rating: |  Discuss |  Briefcase | 4,419 reads

   Items 1 to 1 of 1