Define a Key - "select * from "

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...

Re: Define a Key - "select * from "

On Jul 9, 10:39 am, Stagnight1 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...

You can assign it to Ctrl-V by putting it on the clipboard.

Re: Define a Key - "select * from "

On Jul 9, 9:39 am, Stagnight1 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-da y-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

Re: Define a Key - "select * from "

Stagnight1 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.

I haven't tried it, but
http://www.regsoft.com/keys/

others may be available
http://www.google.com/search?hl=en&q=program+function+keys&b tnG=Google+Search

Andrew