Posts
Sort by recent activity
Redgate celebrates its 25th birthday with community support initiatives - What About The Employees
I just want to say great job to Red-gate for their initiatives announced in an email I got today about it's 25th anniversary. The email says that Red-gate "..reached $100 million in annual recurrin...
Does SQL Prompt Have a Way to show Stored Procedure hierarchies
What exactly is a Stored procedure hierarchy?This is where a SP contains within it a cell (vie EXECUTE) to 1 or more other SP's and within those SP's they may call one or more other SP's.
WARNING - Avoid Upgrading SQL Prompt Until Red-Gate Brings Back Tab History
In an effort to provide its loyal customers with a better and improved version of TAB HISTORY Red-Gate rolled out a new feature named SQL HISTORY that replaces TAB HISTORY. Unfortunately SQL HISTOR...
Is there a way to filter in the Column Picker
When using the Column Picker is there a way to filter by data type? I work with tables that have many columns and it would be great if I could for example filter by data type. Does SQL prompt do this?
Snippet Manager Tip - Date in the Description field
TIP: The Snippet Manager has no date field for specifying when a snippet was created or last updated. For me I have so many snippets that it can be hard to remember the exact code but I may remembe...
Formatting - Table Joins
If there anyway with the SQL Prompt formatting to get the FROM clause to structure the table joins like the below where the first 2 tables are listed on the same row as FROM and subsequent joins a...
Styles - Are there any Customization Options Possible Beyond what is in the Formatting Styles Dialog
Are there any options (i.e. directly editing the files that save the formatting styles) for making customization's to Formatting styles that are not in the Formatting Styles dialog? For example if ...
Auto-create Select Into Code From Table Selection in Query
This may already exists and i simply am unaware of it. If I have a query like this:SELECT Col1,Col2,Colx FROM TABLEA AIs it possible with SQL Prompt to select the table name and with the click of a...
How to enable use of AS only for Columns and not Tables
How do I set SQL Prompt to do this:SELECT T1.col1 AS 'Col1'FROM TABLE1 T1and NOT this:SELECT T1.col1 AS 'Col1'FROM TABLE1 AS T1
Why Are Some Parts of Import/Export Settings excluded
As a dev one of the hardest things is switching between systems, from old to new because the tools I depend on inevitably opt to leave out some portion of what needs to be included when I'm moving ...