Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag WHERE Rss

Search for any content tagged where

   Items 1 to 3 of 3   
 

SQL Prompt 7.2 – Now With Execution Warnings!

Redgate’s code completion tool SQL Prompt now provides you with a handy warning if you try to execute an UPDATE or DELETE statement without a WHERE clause. Bob Pusateri explains why he loves this added layer of protection, and why you should too.  Read more...
By 2016/06/02 | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,567 reads

Conditional WHERE Clauses and Boolean Algebra

Utilize simple boolean algebra and nullable parameters to implement conditional WHERE clauses without dynamic SQL.  Read more...
By Tony Alicea 2010/08/31 | Source: SQLServerCentral.com | Category: conditional
Rating: |  Discuss |   Briefcase | 17,528 reads

SQL WHERE Clause Optimization

SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...   Read more...
By Additional Articles 2009/09/25 | Source: SQL-Server-Pro | Category: t-sql
Rating:  Rate this |   Briefcase | 9,365 reads
   Items 1 to 3 of 3