#SHORT QUOTES DATABASE CODE#
To quickly comment out lines of code you want to omit while testing or troubleshooting a query, highlight the code, press Ctrl and select Comment. You can then access these from the Actions List. You can also create your own custom surround-with snippets utilising the $SELECTEDTEXT$ placeholder in the Snippet Manager. These snippets utilise the $SELECTEDTEXT$ placeholder, so highlight your block of code, hit Ctrl and type BE or TC followed by tab, and it will surround your code block with the necessary SQL. ‘Surround-with’ snippets allow you to enclose a group of SQL statements into a logical block of code, such as a BEGIN…END block, or a TRY…CATCH block. You can see it in action in this short video:Ģ. No more coding in Excel or repetitive quote, comma, arrow. Say you’re copying a list of items to insert data into a table, you can save yourself time manually adding quotes and commas by selecting the block of text, hitting Ctrl to bring up the Actions List, and selecting Add quotes & commas.
In this blog, I’m going to tell you about five functions on the list you might not have come across, which I guarantee will save you a few more minutes each day, every day. Simply highlight your block of code and hit Ctrl, or click on the button to open up the list.
This little button right here is called the Actions List and it contains over 20 functions and snippets you can use in just a few keystrokes. When writing SQL, you can use SQL Prompt to quickly jump to some really handy formatting and refactoring actions.
0 kommentar(er)
