Tag Archives: SQL Prompt

Adding a Format SQL Button to the Redgate Toolbar

I’ve gotten used to CTRL+K,Y to format SQL with SQL Prompt, but a customer wanted a button on the toolbar. It’s fairly easy to do, but I thought I should document the process for others. First, if you click the … Continue reading

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

Quick SQL Prompt Updates in a Pattern

I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool.  SQL Prompt will be yours as well if you give it … Continue reading

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

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

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

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

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

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

I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool.  SQL Prompt will be yours as well if you give it … Continue reading

Posted in Blog | Tagged , , ,

Creating Custom Databases with SQL Prompt

I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool.  SQL Prompt will be yours as well if you give it … Continue reading

Posted in Blog | Tagged , , | 1 Comment