| Author |
Message |
JT
Joined: 06 Aug 2009
Posts: 4
|
 Posted: Mon Nov 12, 2012 3:35 pm Post subject: No brackets with alias |
 |
|
| 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? |
|
| Back to top |
|
 |
Manfred.Castro
Joined: 23 Apr 2012
Posts: 127
|
| Posted: Tue Nov 13, 2012 7:46 pm Post subject: |
|
|
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 |
|
| Back to top |
|
|
JT
Joined: 06 Aug 2009
Posts: 4
|
| Posted: Tue Nov 13, 2012 9:14 pm Post subject: |
|
|
| 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. |
|
| Back to top |
|
|
Manfred.Castro
Joined: 23 Apr 2012
Posts: 127
|
| Posted: Tue Nov 13, 2012 10:15 pm Post subject: |
|
|
This would be considered a feature request.
You can direct feature requests to our uservoice forums.
http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions
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 |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
