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 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
Hi I'm sorry to hear you're having trouble with adding square brackets. I wasn't able to reproduce the issue using your script. Are you highlighting the entire script then running "Add square brackets" (Ctrl + B, Ctrl + B )? What version of Prompt are you using? If you're not on the latest version (7.2.2.273), could you upgrade and see if the behaviour is the same? Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Table varaible suggestion enclosed in square brackets
Hi I'm sorry to hear you're having trouble with adding square brackets. I wasn't able to reproduce the issue using your script. Are you highlighting the entire script then running "Add square brack...
0 votes
Hi Lucas971 We actually improved the datetime support a little while ago after we had similar suggestions from a couple of other users. If you upgrade to the latest version (here) then exporting should work as you described. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Open in Excel (7.1.0.118)
Hi Lucas971 We actually improved the datetime support a little while ago after we had similar suggestions from a couple of other users. If you upgrade to the latest version (here) then exporting sh...
0 votes
Hi Thanks for your suggestion, the best place to log it would be on our UserVoice forum which we use to help track and prioritise new features (plus you'll get notified when we have a new build ready, along with anyone else who's also interested). Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Alias adds additional alias incorrectly
Hi Thanks for your suggestion, the best place to log it would be on our UserVoice forum which we use to help track and prioritise new features (plus you'll get notified when we have a new build rea...
0 votes
Hi Thanks for reporting this, unfortunately there’s no way to stop this behaviour with the current formatting in SQL Prompt. However, we are hard at work on adding a much more powerful formatting system which will give you much better control over this behaviour. When we release the new formatter we’ll announce it on the forums so keep an eye out for this. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Single Line comments move to the next line
Hi Thanks for reporting this, unfortunately there’s no way to stop this behaviour with the current formatting in SQL Prompt. However, we are hard at work on adding a much more powerful formattin...
0 votes
Hi emf411 Currently there's no setting to change the behaviour of NULLs exported to Excel. The best way to log this would be to create a request on our UserVoice forum. Uservoice helps us track and prioritise our work and you'll get status notifications (along with anyone else that's interested). Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt is 7.2.4.291 (22nd June)
Hi emf411 Currently there's no setting to change the behaviour of NULLs exported to Excel. The best way to log this would be to create a request on our UserVoice forum. Uservoice helps us track and...
0 votes
Hi Lenka Sorry to hear you’re having trouble. I haven’t been able to reproduce your issue here so it’d be best if you could contact our support team to investigate it further. Please enable verbose logging and include the logs in your support request. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt is 7.2.4.291 (22nd June)
Hi Lenka Sorry to hear you’re having trouble. I haven’t been able to reproduce your issue here so it’d be best if you could contact our support team to investigate it further. Please enable v...
0 votes
Total activity
91
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
35