Activity overview
Latest activity by JT
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. / comments
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 t...
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 bracket...
Sorry, it's been a mess at work lately and I must have forgotten to be notified of any replies. We have 3.9.0.43 for SQL Prompt and 9.00.4035.00 for SSMS.
Thanks, Jason / comments
Sorry, it's been a mess at work lately and I must have forgotten to be notified of any replies. We have 3.9.0.43 for SQL Prompt and 9.00.4035.00 for SSMS.
Thanks, Jason
We have the same issue. Did Anu's suggestion work for you and, if so, can you please let me know what it was?
Thanks,
Jason / comments
We have the same issue. Did Anu's suggestion work for you and, if so, can you please let me know what it was?
Thanks,
Jason