AutoHotkey SQL Server hotkey to select from highlighted table


/ Published in: Other
Save to your folder(s)

Ctrl F5 will select * from highlighted table. Ctrl Shift F5 will sp_columns. Ctrl J will copy current line to next line.


Copy this code and paste it in your HTML
  1. ;
  2. ; AutoHotkey Version: 1.x
  3. ; Language: English
  4. ; Platform: Win9x/NT
  5. ; Author: A.N.Other <[email protected]>
  6. ;
  7. ; Script Function:
  8. ; Template script (you can customize this template by editing "ShellNew\Template.ahk" in your Windows folder)
  9. ;
  10.  
  11. #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases.
  12. SendMode Input ; Recommended for new scripts due to its superior speed and reliability.
  13. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory.
  14.  
  15.  
  16. ^F5::
  17. Send, {right}^{left}{shift down}^{right}{shift up} ; Select word if not selected already
  18. Send, ^xSELECT TOP 10 * FROM ^v{shift down}{ctrl down}{left}{left}{left}{left}{left}{left}{shift up}{ctrl up}{F5}^v
  19. return
  20.  
  21. ^+F5::
  22. Send, {right}^{left}{shift down}^{right}{left}{shift up} ; Select word if not selected
  23. Send, ^xsp_MShelpcolumns ^v{shift down}{ctrl down}{left}{left}{shift up}{ctrl up}{F5}^v
  24. Sleep, 400
  25. Send, {F6}{right}{right}{right}
  26. return
  27.  
  28. ^j::
  29. Send, {end}{shift down}{home}{shift up}^c{end}{enter}^v
  30. return

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.