Define a Key - "select * from "

#1

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

#2

On Jul 9, 10:39 am, Stagnight1 <stagnig... (AT) yahoo (DOT) com> wrote:

Quote:

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.

#3

On Jul 9, 9:39 am, Stagnight1 <stagnig... (AT) yahoo (DOT) com> wrote:

Quote:

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

#4

Stagnight1 wrote:

Quote:

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...oogle+S earch

Andrew