Quick Tip: Things to remember when using NULL in where clause

Working on one of my project on asp.net and Sql Server has made me learn a lot about both of these technologies. I’ll be sharing my learning and the tricky things which I have learnt here in the form of quick tips.

Here’s the first one. Keep an sharp eye when using NULL in where clause because things wouldn’t be working correctly without you even noticing. Following are the few things which new developers tends to do wrong. And they would’t notice because Sql Server wouldn’t raise any error for these.

  1. Checking for NULL values
  2. Checking for NULL in “IN” condition

Continue reading

Conditional where part in Stored Procedures based on parameter


Many times there comes a situation when we have to add a conditional where part in stored procedure’s query based on the parameters that are been passed to the SP. ┬áLet’s take up an example with the following requirement.

We’ll create a SP “FindProduct” which will have two parameters @id and @searchString and it will return the posts that meet the passed parameters. We want to create our procedure as such that it search for the product if one of these parameter is passed.
Continue reading