Friday, 20 July 2012

SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]


SELECT *
FROM (SELECT *
FROM (SELECT *
FROM (SELECT *
FROM tbl_emp)a)b)c

Now press CTRL+] and you will see that it jumps from b to the opening parenthesis.

SELECT *
FROM (SELECT *
FROM (SELECT *
FROM (SELECT *
FROM tbl_emp)a)b)c

You can once again press CTRL+] and it will jump back to parenthesis after b.





CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis

CTRL+SHIFT + ]   has selected the code between two corresponding parentheses.

SELECT *
FROM (SELECT *
FROM (SELECT *
FROM (SELECT *
FROM tbl_emp)a)b)c






Never regret. If it’s good, it’s wonderful. If it’s bad, it’s experience.




No comments:

Post a Comment