First Post in this series: SQL Advent Calendar 2013-Day 1- Placeholders in SQL Prompt Snippets
As I was hanging our family Advent Calendar up, I thought I would make one for you, my readers. I’ll be sharing my scripts from two of my favorite products as well as tips on how to create your own.
A Needed Siesta
We are half way to Christmas. Can you believe it? Writing this blog series has been great for me, but tonight I’m tired. So with that, I’m going to share some of the Snippets that come with SQL Prompt.
The first two are fun ones. Type Neo + TAB and Yell + TAB and see what you get. They always make me feel better.
If you really want to get into snippets, you can really save on the keep strokes with the following.
| ssf | SELECT * FROM |
| st100 | SELECT TOP 100 * FROM |
| cj | CROSS JOIN |
| ij | INNER JOIN |
| ob | ORDER BY |
| gb | GROUP BY |
What other quick strokes do you think should be added?
Previous Post In Series: SQL Advent Calendar 2013 – Day 11 – Snippet For a New Stored Procedure
Next Post In Series: SQL Advent Calendar – Day 13 – Snippet for New Transactional Procedure
