How can we help you today? How can we help you today?
Ali D
Activity overview Badges (0) Posts (0) Comments (56)

Comments

Sort by recent activity
Hi We’re glad to hear that you’re enjoying using SQL Prompt [image] This is a great feature suggestion and we intend to start work on implementing it soon. We have a similar idea on our UserVoice page, if you vote on it you’ll be notified when we’ve released a new version with this feature in it. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Update without where warning
Hi We’re glad to hear that you’re enjoying using SQL Prompt This is a great feature suggestion and we intend to start work on implementing it soon. We have a similar idea on our UserVoice page...
0 votes
Hi rbielaws Unfortunately I haven’t been able to reproduce this behaviour, did it happen multiples times or was it just a single incident? Since v7.1 we’ve made some changes to how SQL Prompt handles keyboard commands in SSMS. Could you update to the latest version (v7.2) and let me know if it happens again? Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Script Object as ALTER gets stuck
Hi rbielaws Unfortunately I haven’t been able to reproduce this behaviour, did it happen multiples times or was it just a single incident? Since v7.1 we’ve made some changes to how SQL Prompt h...
0 votes
Hi Maurice It’s good to hear you’ve made some progress. Refreshing the suggestions (Ctrl + Shift + D) updates objects for the current database connection. To clear out and refresh all suggestions you can disable suggestions (Ctrl + Shift + P) and enable them again (using the same shortcut). Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Synonyms wildcard not expanding
Hi Maurice It’s good to hear you’ve made some progress. Refreshing the suggestions (Ctrl + Shift + D) updates objects for the current database connection. To clear out and refresh all suggestio...
0 votes
Hi Maurice Can you think of anything special about the affected synonyms? For example were the underlying objects/views newly created? Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Synonyms wildcard not expanding
Hi Maurice Can you think of anything special about the affected synonyms? For example were the underlying objects/views newly created? Thanks Ali
0 votes
Hi Maurice It sounds like suggestions haven’t been loaded for the referenced database (which is turned off by default). You can turn this feature on by going to SQL Prompt > Options > Suggestions > Connections and checking “Load referenced databasesâ€. [image] If loading referenced databases is enabled and the suggestions still aren't being shown then please let me know. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Synonyms wildcard not expanding
Hi Maurice It sounds like suggestions haven’t been loaded for the referenced database (which is turned off by default). You can turn this feature on by going to SQL Prompt > Options > Suggestions...
0 votes
Hi Unfortunately it’s not possible to stop the NULL getting pushed to the next line with SQL Prompt’s current formatting system. However, we’re quite close to finishing a much more powerful formatting system which will support the formatting you want for your example statement. This new formatting system will be released in the next SQL Prompt beta. Sorry for the delay. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. How to prevent certain new lines?
Hi Unfortunately it’s not possible to stop the NULL getting pushed to the next line with SQL Prompt’s current formatting system. However, we’re quite close to finishing a much more powerful f...
0 votes
Hi Steve You’re correct but unfortunately the formatting system in v7.2 doesn’t fully support SQL Server 2016 syntax. The upcoming v7.3 beta’s formatting system will support this syntax but since IF EXISTS is quite simple I’ll look into adding support for it in v7.2 now. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. DROP TABLE IF EXISTS dbo.MyTable flagged as invalid
Hi Steve You’re correct but unfortunately the formatting system in v7.2 doesn’t fully support SQL Server 2016 syntax. The upcoming v7.3 beta’s formatting system will support this syntax but s...
0 votes
Hi Steve I’ve had a look at supporting IF EXISTS in Prompt’s current formatting system. Unfortunately, because we’re in the middle of transitioning to a new and improved formatting system, backporting syntax support at this point is quite complex. This new formatting system supports IF EXISTS and will be released in the next Prompt beta. Sorry for the delay. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. DROP TABLE IF EXISTS dbo.MyTable flagged as invalid
Hi Steve I’ve had a look at supporting IF EXISTS in Prompt’s current formatting system. Unfortunately, because we’re in the middle of transitioning to a new and improved formatting system, ba...
0 votes
Hi We’ve been able to reproduce this behaviour and have implemented a fix in this private build. Normally inserting square brackets around table variables is useful for accessing columns. We’ve now added some logic to check whether the parameter is a table type before surrounding it with square brackets. Please could you download the private build and let us know if it works as you’d expect? If so, we’ll include it in the next public release. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Table varaible suggestion enclosed in square brackets
Hi We’ve been able to reproduce this behaviour and have implemented a fix in this private build. Normally inserting square brackets around table variables is useful for accessing columns. We’ve...
0 votes
Apologies, I misunderstood the problem you were having. I’ll take another look at reproducing it. / comments
  1. Community
  2. SQL Prompt
  3. Table varaible suggestion enclosed in square brackets
Apologies, I misunderstood the problem you were having. I’ll take another look at reproducing it.
0 votes
Total activity
91
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
35