Tag Archives: SQL Prompt

What’s the little popup window in #SQLPrompt?

Awhile back I was working in SSMS and saw this window. It threw me off since I was trying to write some code and hadn’t expected it. I clicked Escape, Enter, a few things and was getting frustrated when it … Continue reading

Posted in Blog | Tagged , , | Leave a comment

The GUI Helps Build SQL Prompt Snippets

SQL Prompt is an amazing tool for writing T-SQL. It helps you to concentrate on your code, without having to go off and examine Books Online or other documentation, or even worry about formatting. One of the keys to making … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Creating Custom Databases with SQL Prompt

SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself to use a few of these and not just start to type with your old habits. This quick tip looks … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Using TRY..CATCH in SQL Prompt

I learned something new recently about SQL Prompt. I was working on documenting and experimenting with snippets and found a quicker way to write code. One of the things I think is great is to use the TRY..CATCH structure. I … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

The Snippet Manager in SQL Prompt

I love SQL Prompt, since it makes T-SQL coding quicker and easier. One of the handiest things is the Snippet Manager. I’ll show you how this works. When I type something, like “cl”, I get a list of things, as … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

My SQL Prompt GitHub Repo

Last year I published an article on SQLServerCentral from Guarav Vohra on using SQL Prompt with a VCS. I really like the article, and had been meaning to get my own SQL Prompt Snippet library into a repo, but kept … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Quick Tips–Using ii in #SQLPrompt

SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself to use a few of these and not just start to type with your old habits. This quick tip looks … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Quick #SQLPrompt Tips – Expanding Wildcards

I tend to try and get code on the screen quickly and then start to remove things. I’m a visual person, and it’s helpful for me to see some tables, joins, filters, and columns as I’m structuring a query. One … Continue reading

Posted in Blog | Tagged , , | Leave a comment

SQL Prompt Prevents Stupidity

I upgraded my SQL Prompt recently, mostly as a habit. The team led by David and Aaron are always adding cool new features, and have almost never broken my flow, so I usually take the changes they’ve made whenever they … Continue reading

Posted in Blog | Tagged , , | 12 Comments

Custom Placeholders in SQL Prompt 7

I love my snippets in SQL Prompt. Adding some snippets can make work go so much quicker.  I add new ones all the time, based on the tasks I’m doing and I find that code can almost write itself. SQL … Continue reading

Posted in Blog | Tagged , ,