Comments
Sort by recent activity
Maybe an idea is a "Code Gallery" for snippets somewhere on the site
I know I have created a fair number of personalised ones as I'm sure many people have.
"Share and Enjoy" --- HHG sded =
DECLARE @StartDate DateTime
DECLARE @EndDate DateTime
Set @StartDate = DateAdd(d,-1,GETDATE())
Set @EndDate = GETDATE()
/ comments
Maybe an idea is a "Code Gallery" for snippets somewhere on the site
I know I have created a fair number of personalised ones as I'm sure many people have.
"Share and Enjoy" --- HHGsded =
DECLARE...
Hi Tanya
I can be a bit vague !!
I use the facility of hovering over a name to see the script of the SP , if I have a line that is EXEC spName , I use the hover to get the script , copy it and paste it to a new window so that I can see whats going one in the called SP.
If the called SP has been changed since the last Cache Refresh , its shows me the OLD version , If I refresh the Cache I see the NEW one.
I think you've answered it ,if any changes are made they only reflect after a manual update or Cache refresh.
It would be nice , that if the schema of a SP is copied to clipboard , that it be the live one , not the Cached one .
Using the hyperlink to get the text of an SP is nice feature ,just in this instance , a bit confusing.
Cheers
Mike / comments
Hi Tanya
I can be a bit vague !!
I use the facility of hovering over a name to see the script of the SP , if I have a line that is EXEC spName , I use the hover to get the script , copy it and past...
Hi
I have managed to activate the product by doing exactly as you said , but its not a simple method , I literally had to ban my wife from logging onto our PC in her name while I left the activation wizard open for 8 hrs plus, which you can imageine pleased her a lot !!
I appreciate the need to verify legitimate license holders but its not very convenient for the "customer".
That said I should be fine til I buy a new PC
Justa thought for future issues maybe
Cheers
Mike / comments
Hi
I have managed to activate the product by doing exactly as you said , but its not a simple method , I literally had to ban my wife from logging onto our PC in her name while I left the activatio...
Seems only to happen if the String is outside of a sql statement
Open a new query window type 'Measurement Type' and you get caps TYPE
now type
SELECT * FROM BBT WHERE BBTCode ='Meaurement Type' and you get lower case
Type simply Meaurement Type again and still lower case.
I can only make it happen when its the first line of a clean window so far. / comments
Seems only to happen if the String is outside of a sql statement
Open a new query window type 'Measurement Type' and you get caps TYPE
now type
SELECT * FROM BBT WHERE BBTCode ='Meaurement Type' an...
"Don't miss me " [image] , my intial reactions are in the main forum
But seriously , I will get back with more as I continue working with it, as I said above , I am well pleased with the improvements I have spotted so far .
Is there a "list" of enhancements , fixes etc that I have missed, I would hate to not see something
Cheers
Mike / comments
"Don't miss me " , my intial reactions are in the main forum
But seriously , I will get back with more as I continue working with it, as I said above , I am well pleased with the improvements I ha...
Hi
Without "punting" another Red Gate Product ( which I will !!) have you looked at SQL Refactor , which you can configure very flexibly to position columns all in one line , or new line etc , pre comma's post comma's , and loads more
Its a nice tool to "Order the Mess" of a lot of stored procs I have seen ..
Even some of my own
"Write scruffy , tidy up once your'e done" -- probbaly not quite best practice but >>>
Mike / comments
Hi
Without "punting" another Red Gate Product ( which I will !!) have you looked at SQL Refactor , which you can configure very flexibly to position columns all in one line , or new line etc , pre ...
This is the same for Update , it gives you the UPDATE() function first rather than the the Normal UPDATE
Also IN (INFORMATION_SCHEMA >>>) , and I am sure many more
Will there be a means to disable unwated completions or to re order tehm to allow individual styles and usages ?
Cheers
Mike / comments
This is the same for Update , it gives you the UPDATE() function first rather than the the Normal UPDATE
Also IN (INFORMATION_SCHEMA >>>) , and I am sure many more
Will there be a means to disable ...
Hi Chris
Thanks for that , there are a couple of "completions" that you work around like this , for example the information_Schema one that intercepts IN ,these are in as snippets with shortcuts , eg make it infsc instead of in , I use that shortcut very infrequently so an extra few letters ....
Some however aren't such as the Update() function.
I have created a snippet <up = UPDATE> which now appears above the built in UPDATE() Function , so it fixes the problem , you just have to be carefult not to get carried away and type the UPD as this now goes to the UPDATE() Function.
All in all you can normally get around most of the unwanted insert with an appropriate Snippet of your own .
After all its a small price to pay for the massive typing saving that SQL Prompt gives us . I remain an "addict" , SQL without SQLPrompt would be unthinkable now.
Cheers
Mike / comments
Hi Chris
Thanks for that , there are a couple of "completions" that you work around like this , for example the information_Schema one that intercepts IN ,these are in as snippets with shortcuts , ...
Hi Bart
Corporate SV from Norton , Symatec Antivirus v 10.5.1.500
Cheers
Mike / comments
Hi Bart
Corporate SV from Norton , Symatec Antivirus v 10.5.1.500
Cheers
Mike
Hi Tanya
As ever our security buffs an FTP !!
Could you mail me the version as a Zip file with the p Missing ( SQLPrompt.zi_) and I'll restore it to its former glory.
That normally gets through our firewall
Bart managed this in the past
Cheers
Mike / comments
Hi Tanya
As ever our security buffs an FTP !!
Could you mail me the version as a Zip file with the p Missing ( SQLPrompt.zi_) and I'll restore it to its former glory.
That normally gets through our...