Home Forums SQL Server 2005 T-SQL (SS2K5) How to write Conditional Where Clause RE: How to write Conditional Where Clause

  • June 17, 2009 at 1:29 am

    #1010672

    GilaMonster (6/17/2009)

    Just a couple things with that.

    It's likely to perform badly. Take a look at the blog post I referenced earlier. Also, before you use nolock, read this: http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

    Hi Gila,

    As i am a newbie i donno so,

    What bad effect will the query with 'case in where clause' bring ?