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.