Skip to content

How can we improve SQL Prompt?

SQL Prompt: Format SQL

CATEGORIES
All ideas
My feedback
Code Analysis 48 ideas
Encapsulate as new stored procedure 1 idea
Expand wildcards 7 ideas
Find invalid objects 7 ideas
Find unused variables 3 ideas
Format SQL 187 ideas
Intellisense 77 ideas
Platform Support 16 ideas
Qualify object names 6 ideas
Script object as alter 14 ideas
Smart rename 10 ideas
Summarize script 5 ideas
Tab coloring 5 ideas
Tab history 42 ideas
User interface 88 ideas

Searching…

No results.
Clear search results

- Flyway 15 ideas
- MySQL tools 24 ideas
- Oracle 129 ideas
- Redgate 0 ideas
- SQL Change Automation 50 ideas
- SQL Compare 249 ideas
- SQL Data Compare 110 ideas
- SQL Prompt 663 ideas
- SQL Search 133 ideas
- SQL Source Control 588 ideas
- SQL Toolbelt Essentials 16 ideas
Redgate

SQL Prompt > Format SQL Update for SQL Server 2016

Any query where "AT TIME ZONE" is used (new feature in SS '16), the Format SQL throws and error.

"SQL Prompt was unable to complete this operation. Problem areas have been highlighted"

The highlighting start from "AT TIME ZONE..."

Thank you

14 votes

Anonymous shared this idea · Jan 24, 2017 · Report… · Admin →

completed ·

Michael Clark responded · May 12, 2017

We now support “AT TIME ZONE” in the latest release of SQL Prompt. You can download the latest release here:
https://forum.red-gate.com/discussion/80988/latest-stable-build-of-sql-prompt-is-8-0-0-1241-11th-may#latest

Thanks for your support!

An error occurred while saving the comment