No brackets with alias

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

No brackets with alias

Postby JT » Mon Nov 12, 2012 3:35 pm

I have an indexed view that I created a specific alias for which includes the WITH (NOEXPAND) option. My problem is that Prompt 5 is wrapping the entire alias (with the NOEXPAND option) in brackets. Is there a way to disable the automatic brackets?
JT
 
Posts: 4
Joined: Thu Aug 06, 2009 8:32 pm

Postby Manfred.Castro » Tue Nov 13, 2012 7:46 pm

There is an option to enclose identifiers within square brackets in
SQL Prompt 5>Options>Inserted Code>Special Charachters
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby JT » Tue Nov 13, 2012 9:14 pm

That option is unchecked for me so it is not causing my problem. Prompt 5 is checking to see if it is a reserved word (like SELECT) or has spaces and is automatically putting the brackets around the alias. However, in my case, I don't want this behavior.
JT
 
Posts: 4
Joined: Thu Aug 06, 2009 8:32 pm

Postby Manfred.Castro » Tue Nov 13, 2012 10:15 pm

This would be considered a feature request.
You can direct feature requests to our uservoice forums.
http://redgate.uservoice.com/forums/944 ... uggestions
These forums are actively monitored by our development team and allow our users to reuest features and vote on them.
If a feature recieves a significant amount of votes or is deeemed to have merit development may include the feature in a future release.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests

cron