For the month of September I’m challenging myself to perform two different feats of strength:
- Do 5,000 push-ups in the month of September
- Post a SQL Developer Tip or Trick every day for the next 30 days
I’ve noticed my posts are starting to go out once or twice a week, and I like to average three. So hopefully this mini-bootcamp of blog posts will me back on schedule.
So, without further ado, Tip #1:
How to Get Help with your WHERE Clauses
It’s all about the cursor.
If you type ‘WHERE’ and invoke the helper, via Ctrl+Spacebar:
If you type ‘WHERE ‘ and invoke the helper:
Note the space after the WHERE when invoking the helper.
Since I’ll be blogging a tip or trick every day for the next 30 days, most of these will be shorter and easier for you to digest, I hope!