|
|
Posted by M Bourgon on 07/10/07 20:50
On Jul 9, 9:39 am, Stagnight1 <stagnig...@yahoo.com> wrote:
> Is there a way to define a key that puts the text 'SELECT * FROM '
> into the Query Analyzer window?
> I must type this about 50 times a day but cannot see a simple way of
> defining a key to write it for me..
> (tools/customize) seems to execute everything you put in there rather
> than leave it on the screen for me to add table names etc to.
>
> thanks for your time...
There's a handful of ways. One way is (in QA) Tools->Customize. You
can set CTRL+[0..9] to be a snippet of code, but invoking it runs it.
I put frequently-used code there and just copy it as necessary.
SQLPrompt 2/3 - clever idea, but implementation is still iffy.
Sometimes it works, sometimes it doesn't, sometimes it crashes QA.
What I think will suit you best is Lifehacker's "Texter" (http://
lifehacker.com/software/text-substitution/download-of-the-day-texter-
windows-242812.php). No, it's not smart, but it will convert "ssf" to
"select * from", and it works flawlessly. Oh, and hey, free. Even
better.
Hope this helps.
M
Navigation:
[Reply to this message]
|