Tuesday, June 11, 2013

SQL Tips and Tricks

  1. Use Keyboard shortcuts in Tools->options for generating regular results sets like sp_helptext and sp_help.
  2. When you see ant procedure breaking the If condition logic even the business logic is fine , the best and foremost thing you need to do is to verify the DataType of the variable used in If condition.Remember if you mistakenly used bit for variable x and doing the comparison of integer say x>5 it always go to else condition.The reason the Bit contains 1 values in true case and 0 value in false case.

No comments: