How can we help you today? How can we help you today?
Michael Clark
Activity overview Badges (0) Posts (7) Comments (115)

Comments

Sort by recent activity
Hi Naumad, Sorry to hear that our column suggestions aren't always appearing. Would it be possible to try updating to the latest version of SQL Prompt? Have you managed to identify a pattern when the suggestions appear? Does it only affect col1 in your example or all columns? row_number() over (partition by col1, col2, col3 order by col0 desc) as x Best, Michael Clark Technical Lead, SQL Prompt / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt Suggestions do not appear in Row_Number clause
Hi Naumad, Sorry to hear that our column suggestions aren't always appearing. Would it be possible to try updating to the latest version of SQL Prompt? Have you managed to identify a pattern when t...
0 votes
Just a quick note -- we are tracking this bug under reference SP-6199. / comments
  1. Community
  2. SQL Prompt
  3. Setting incorrect alias
Just a quick note -- we are tracking this bug under reference SP-6199.
0 votes
Hi naumad, Like James, I'm having trouble reproducing this one. Would it be possible to have a larger script where the problem occurs? Would it be possible to try our new formatting engine and let us know if the problem still occurs? This is currently an experimental feature which you can turn on by going to "SQL Prompt > Options > Labs > Experimental Features" and selecting the "Use new formatting styles" checkbox. That will help us narrow down the cause. Thanks, Michael Clark Technical Lead, SQL Prompt / comments
  1. Community
  2. SQL Prompt
  3. Format SQL mistaking 'at time zone' as column alias
Hi naumad, Like James, I'm having trouble reproducing this one. Would it be possible to have a larger script where the problem occurs? Would it be possible to try our new formatting engine and let ...
0 votes
Just a quick note -- we are tracking this alias bug as SP-6200 / comments
  1. Community
  2. SQL Prompt
  3. Format SQL mistaking 'at time zone' as column alias
Just a quick note -- we are tracking this alias bug as SP-6200
0 votes
Hi A13Guest, Sorry to hear you are having trouble connecting to SQL Server on Linux. Unfortunately we do not support SQL Server on Linux at the moment (see full list of supported platforms). If you want SQL Prompt to work with SQL Server on Linux, would it be possible to add a feature request on our UserVoice page? https://redgate.uservoice.com/forums/94413-sql-prompt Best, Michael Clark Technical Lead, SQL Prompt / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt - Master Failed To Load - Linux
Hi A13Guest, Sorry to hear you are having trouble connecting to SQL Server on Linux. Unfortunately we do not support SQL Server on Linux at the moment (see full list of supported platforms). If you...
0 votes
Hi Ozzie, We have produced a private build for you with a fix for the case sensitive check. You can download it here. Would it be possible to check if this build resolves the issue? Thanks, Michael / comments
  1. Community
  2. SQL Prompt
  3. Slight Bug
Hi Ozzie, We have produced a private build for you with a fix for the case sensitive check. You can download it here. Would it be possible to check if this build resolves the issue? Thanks, Michael
0 votes
Hi Ogrishman, The commands you pasted are predefined code refactorings. Unfortunately it is not possible to create custom user defined actions. What we you looking to create? Would it be possible to explain more? Thanks, Michael / comments
  1. Community
  2. SQL Prompt
  3. How to create user defined actions like this?
Hi Ogrishman, The commands you pasted are predefined code refactorings. Unfortunately it is not possible to create custom user defined actions. What we you looking to create? Would it be possible t...
0 votes
Hi Torsten, Could you confirm that you are using our new beta formatting system? We will add this to our formatting backlog of items to consider before releasing the full version (reference SP-6070). Thanks, Michael / comments
  1. Community
  2. SQL Prompt
  3. Insert values
Hi Torsten, Could you confirm that you are using our new beta formatting system? We will add this to our formatting backlog of items to consider before releasing the full version (reference SP-6070...
0 votes
Hi Torsten, Thanks for your post! If you think this enhancement would be useful, would it be possible to post this feature on our UserVoice so that other users can vote on it? You can access SQL Prompt's UserVoice here: https://redgate.uservoice.com/forums/94413-sql-prompt Thanks, Michael / comments
  1. Community
  2. SQL Prompt
  3. MIXED_PAGE_ALLOCATION
Hi Torsten, Thanks for your post! If you think this enhancement would be useful, would it be possible to post this feature on our UserVoice so that other users can vote on it? You can access SQL Pr...
0 votes
Hi Torsten, Sorry to hear that you've run out of votes, but thanks for all the great feedback on UserVoice. We have added a ticket for this and will let you know when we fix it: SP-6078 Code completion - Setting MIXED_PAGE_ALLOCATION is not covered Thanks, Michael / comments
  1. Community
  2. SQL Prompt
  3. MIXED_PAGE_ALLOCATION
Hi Torsten, Sorry to hear that you've run out of votes, but thanks for all the great feedback on UserVoice. We have added a ticket for this and will let you know when we fix it: SP-6078 Code comple...
0 votes
Total activity
215
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
93