Comments
Sort by recent activity
Hi
Some of tables use a PK___ID and FK____ID as joins , these normally show in teh suggestion list but not at the top.
It would be nice to see them promted to teh top based on the ____ID matches ignoring the PK & FK prefixes .
If that makes sense
Mike / comments
Hi
Some of tables use a PK___ID and FK____ID as joins , these normally show in teh suggestion list but not at the top.
It would be nice to see them promted to teh top based on the ____ID matches ig...
I raised this during the Beta phase and the response was that "this was the desired behaviour from the users"
I agree I would prefer the top line to be highlighted and just Tab , in most cases its the selection you're loking for
Mike / comments
I raised this during the Beta phase and the response was that "this was the desired behaviour from the users"
I agree I would prefer the top line to be highlighted and just Tab , in most cases its ...
Hi David
Have a look at Whole Tomato -- Visual Assist X , they have what they call Acronyms, its an Add In to Visual Studio to enhance the native Intellesence
If you have an object say processDataSet , then simply typing <pds> puts the processDataSet at the top of the list, hit tab and move on.
It works for objects , variables etc.
It has the same effect as SQL Prompt in that you almost get to code in shorthand but it also allows you to use horribly complicated names for things , eg ProcessIDComboBox , is a default name when you drag processID from the DataSource menu , it would be a pain to code manaually but <pidcb> gets you there. You sort of get used to picking in acronyms after a while.
Imagine ssf xyz and your statement completes for a table X......Y......Z......, or am i just being too lazy
they are www.wholetomato.com
Hope this helps
PS well done on version 4 , despite all the niggles in teh forum , I have had very little trouble since you issued the patch
Cheers
Mike / comments
Hi David
Have a look at Whole Tomato -- Visual Assist X , they have what they call Acronyms, its an Add In to Visual Studio to enhance the native Intellesence
If you have an object say processDataS...
WOW
You learn something new every day , the other way to do it is if you are in an sp that calls another sp or fnc , just highlight the Sp name and the dialog opens , copy to clipboard and paste into a new query .
But beware if the source sp have changed you may get an older version unless you have refeshed the schema / comments
WOW
You learn something new every day , the other way to do it is if you are in an sp that calls another sp or fnc , just highlight the Sp name and the dialog opens , copy to clipboard and paste in...
look at the sticky for the snippet importer tool above , it works fine , I imported all my V3 ones and they merged with the V4 set
Cheers
Mike / comments
look at the sticky for the snippet importer tool above , it works fine , I imported all my V3 ones and they merged with the V4 set
Cheers
Mike
I am not seeing the wildcard prompt on Table Variables at all
Temp tables list the columns in column order / comments
I am not seeing the wildcard prompt on Table Variables at all
Temp tables list the columns in column order
Thanks Tanya
Funny I find it irritating not to be there , maybe because SQL Prompt is SOOOO good it always gets it right for me
Its also a design thing I suspect if you keep you FK's and PK's with the same name in both joined tables it works like a charm , I hate the prefix PK...ID and FK...ID , which also sometime fools SQL Prompt
Still I'm happy to live with it
Mike / comments
Thanks Tanya
Funny I find it irritating not to be there , maybe because SQL Prompt is SOOOO good it always gets it right for me
Its also a design thing I suspect if you keep you FK's and PK's with ...
I use Ctr K Y regularly , probably more than the menu options , I have seen no problem
I have a SSMS isntance open most of the time unless I reboot , maybe that has an impact
Mike / comments
I use Ctr K Y regularly , probably more than the menu options , I have seen no problem
I have a SSMS isntance open most of the time unless I reboot , maybe that has an impact
Mike
Have look under Options in The SQL Prompt 4 menu , you see Aliases half way down , there is a checkbox to capitalise Aliases , just uncheck it
Mike / comments
Have look under Options in The SQL Prompt 4 menu , you see Aliases half way down , there is a checkbox to capitalise Aliases , just uncheck it
Mike
Thanks George
Spot on , it must be case sensitive now
I only just spotted that the install has imported all my snippets , I was going to use the Snippet import tool you created but no need now
The beta is looking good so far , most of the Early Access niggles seem to have been fixed
Cheers
Mike / comments
Thanks George
Spot on , it must be case sensitive now
I only just spotted that the install has imported all my snippets , I was going to use the Snippet import tool you created but no need now
The ...