Tag Archives: SQL Prompt

Disabling #sqlprompt Formatting

I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want code reformatted. One great example is when I write INSERT statements. Here’s what I might write: INSERT dbo.Payments_A   ( … Continue reading

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

Useful #SQLPrompt Tips

One of the tools that Redgate write is SQL Prompt. This might be my favorite product, and I’m constantly impressed by the improvements that the dev team releases. In fact, I’m also impressed by the rate at which they produce … Continue reading

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

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

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