title: Conditional Check in Where clause
body: <p>i have a procedure in which the below condition is to be written in a WHERE clause. How do I do that.</p>
  
  <p>itemid is a parameter which can be null.</p>
  
  <p>if itemid is available then add it to my where clause,else do nothing </p>