![]() ![]() Using the multi-line trick doesn't work as well, because we have the dates in different places on the different lines (off by one character). If I wanted to edit the dates, maybe change to 2019 because I've mistyped this or am testing something. INSERT INTO Workout (WorkoutDate, ActivityGroup, WorkoutTime) I see this type of structure often in work I might do. I can then let go of these key and hold down Shift to arrow and select multiple characters.Īs in SSMS, I can type different items then in this space. In ADS, if I want this to work, I need to use CTRL+ALT and then down arrow. ![]() For example, I can use ALT+Shift+arrows to highlight more than one line in SSMS. In SSMS, some of you may know that you can use Shift+Alt with arrow keys to work with the same space across multiple lines. This can make it much easier to look at some code and hide other code, like parameter checks. If I click on any of these down arrows, a section of code will collapse. Suppose I have some code, I can put my cursor in the left sidebar, and I'll see some arrows. It sometimes seems like I'll be working with two pieces of code and I have lots of stuff in the way. While we would all love to see procedures and batches of code limited to what's on the screen, that's often not possible. If you're like me, sometimes you get lots of code in a file. We'll look at some editor tricks, handy extensions, and some customization. There are a few neat things that I have found to make it easier to work with code that I want to show here. Coding TricksĪDS is designed to be a lightweight, quick and easy to use editor for coding T-SQL. Keep up to date with these, as the team at Microsoft is constantly evolving things. There's one every month, as well some hotfixes. The main sections in this article are:ĪDS has changed quite a bit since my last article, with lots of updates. I'll cover some of the ergonomic features, as well as how different languages might be used in ADS. This article continues the series, looking at some of the tips and tricks that might help you work a little more effectively in Azure Data Studio. If there are other features you're interested in, let me know.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |