Now you can see all the PurchIds starting with Speech marks. In order to bring the speechmark in the front, enter ^ in ‘FIND WHAT’ and use single speech mark ‘ in the ‘REPLACE WITH’. I have appx 356 purchIds and i am using the shortin Notepad++ to decorate with speech marks Copy the field values from the result window of the query Using Notepad++ helped me to do these instantly. So the challenge here is : when selecting the ‘PurchId’ values from result window, we need to decorate it with Speech marks and separate them with commas in order to supply these values to another query. Let us say, I am extracting the data from PurchTable with some conditions and PurchIds from the result will be used in another query. For instance, when working with a bulk data, we extract from the table based on pre-defined conditions and use in another query to proceed with further manipulations. There are situations where we need to extract the data, update it and use the same for our unit testing. It also helps a developer to edit the code as it recognizes popular coding languages.Īs a developer, I found it useful not only for the purposes listed above but also in formatting the SQL query values as per the needed format.ĭuring Unit testing phase, developers often swap between FO and SQL data to validate their test results. We often use Notepad++ for easy editing which allows us to open multiples file simultaneously.

How to use notepad++ for sql