Activity overview
Latest activity by James R
Hi @dmckee11 ,
What version of SQL Prompt are you using? We recently released version 8.2 which contains new formatting options for both INSERTS and VALUES.
Hope this helps!
James / comments
Hi @dmckee11 ,
What version of SQL Prompt are you using? We recently released version 8.2 which contains new formatting options for both INSERTS and VALUES.
Hope this helps!
James
Hey @zhiyounet,
Thanks for the report. Unfortunately I haven't been able to reproduce the issue here, if possible can you give me some more information?
What version of SQL Server are you connecting to?
What's the definition of the procedure sp_CheckInv_IA?
Thanks!
James / comments
Hey @zhiyounet,
Thanks for the report. Unfortunately I haven't been able to reproduce the issue here, if possible can you give me some more information?
What version of SQL Server are you connectin...
Regarding INSERT/VALUES, keep your eyes peeled for an exciting update in the next few days [image]
James / comments
Regarding INSERT/VALUES, keep your eyes peeled for an exciting update in the next few days
James
Hey @torsten.strauss
Thanks for the post! The formatting of function calls is something we've known isn't good enough for a while. We've logged in our system and we'll take a look at it soon [image]
Regards,
James / comments
Hey @torsten.strauss
Thanks for the post! The formatting of function calls is something we've known isn't good enough for a while. We've logged in our system and we'll take a look at it soon
Regar...
Hey @Number2 ,
Just to check, have you tried turning off the formatting option under Global > Casing > User-defined objects > Use object definition case? I think that the Key and Value columns are declared as camel-case.
If this doesn't help then let me know!
Thanks,
James / comments
Hey @Number2 ,
Just to check, have you tried turning off the formatting option under Global > Casing > User-defined objects > Use object definition case? I think that the Key and Value columns are ...
Hi @Ngainer ,
Thanks for the post. Unfortunately I can't reproduce this issue locally in SQL Prompt. As long as the Object explorer has been refreshed and is up to date and you have ran Refresh Suggestions (Ctrl+Shift+D) then I can select the type fine.
To help reproduce the issue, could you give me a bit more information?
1. If you query the sys.table_types system table are your user defined types there?
2. Can you send me the definition of your type and an example query you're trying to run 'Select In Object Explorer' from? Just in case this is only failing in a specific type of statement.
Thanks for your patience!
James / comments
Hi @Ngainer ,
Thanks for the post. Unfortunately I can't reproduce this issue locally in SQL Prompt. As long as the Object explorer has been refreshed and is up to date and you have ran Refresh Sug...
Hey @athornbury ,
Thanks for the post. There's no way to do this currently unfortunately, but I agree we should be able to! We'll look into it and hopefully have a fix out soon [image]
Thanks for your patience
Regards,
James / comments
Hey @athornbury ,
Thanks for the post. There's no way to do this currently unfortunately, but I agree we should be able to! We'll look into it and hopefully have a fix out soon
Thanks for your pat...
Hi @kenneyh ,
Thanks for your post! We've managed to reproduce this issue here and have come up with a fix - hopefully it will be released in the middle of next week [image]
Regards,
James / comments
Hi @kenneyh ,
Thanks for your post! We've managed to reproduce this issue here and have come up with a fix - hopefully it will be released in the middle of next week
Regards,
James
Hey Terence_H ,
Thanks for the suggestion!
Unfortunately I'm not sure there's a lot we can do about the structure of SQL - it would certainly need a lot of thought put into it.
It's definitely a cool idea though, could you post a suggestion to our Uservoice page https://redgate.uservoice.com/forums/94413-sql-prompt and potentially we'd get round to investigating the idea if it gets voted on.
A workaround might be to make use of some existing snippet functionality in SQL Prompt. If you change the order of placeholders you can automatically get the cursor to move between code - potentially even back to the columns in a SELECT.
For example, a simple modification of the 'ssf' snippet could look like 'SELECT $column$ FROM $table$', and if you list $column$ as the second placeholder it will prompt you to type the table name first, followed by the columns.
Sorry I couldn't be more help!
Regards,
James / comments
Hey Terence_H ,
Thanks for the suggestion!
Unfortunately I'm not sure there's a lot we can do about the structure of SQL - it would certainly need a lot of thought put into it.
It's definitely a co...
Hi @ahdung,
If you navigate to [All tabs] and right-click on an item that isn't currently open you can choose "Remove tabs older than this" which should remove all of the tabs you want [image]
If this doesn't work then let me know and we'll look into a different solution.
Thanks!
James / comments
Hi @ahdung,
If you navigate to [All tabs] and right-click on an item that isn't currently open you can choose "Remove tabs older than this" which should remove all of the tabs you want
If this doe...