Tag Archives: SQL Prompt

Getting My Alias in #SQLPrompt

I got a tweet after my SQL Prompt formatting piece that said a user would be interested in upgrading from v5 if “as ‘Alias’” was transformed into “’Alias’ = “. Well, in v7.3, this is in there, and I didn’t … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Quick Prompt Tips–Custom Procedure Templates

One of the things that I often do is create stored procedures. The syntax for doing so is simple, but it has a number of items that need to be included. SQL Prompt makes this much quicker with the “cp” … Continue reading

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

New Formatting in #SQLPrompt

I love SQL Prompt. This might be my favorite tool from Redgate Software and just when I thought it couldn’t be any better, a new formatting engine has been released. Reading through existing source code and understanding the intent is … Continue reading

Posted in Blog | Tagged , , | 1 Comment

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 , , | 4 Comments

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 , , ,

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 , ,