The good news is that you can change this default selection to whatever you like by following these steps: Click on Tools in the menu, and then Options Select SQL Server Object Explorer. Set both these values to 0 You can obviously change the values for each as you wish for example for select top rows , but if you would like to select and edit all the rows, change these values to 0 Selecting all Rows in SSMS Now if you go back into SSMS and right-click on a table, you will see that the Context Menu options have changed to Select and Edit All Rows.
Share on Facebook Share. Share on Twitter Tweet. Share on Pinterest Share. In the below example we have set the value as 50 for both options. Once you have made the above mentioned changes right click the table to see the changes as shown in the snippet below. Ashish Kumar Mehta is a database manager, trainer and technical author. Over the last few years, he has also developed and delivered many successful projects in database infrastructure; data warehouse and business intelligence; database migration; and upgrade projects for companies such as Hewlett-Packard, Microsoft, Cognizant and Centrica PLC, UK.
NET Framework 2. Simple once you know, but I was looking everywhere for this. Really appreciate it. Your email address will not be published. This site uses Akismet to reduce spam. Fruchtzwerg 9, 12 12 gold badges 38 38 silver badges 45 45 bronze badges. Shah Shah 1 1 silver badge 2 2 bronze badges. Might work in too. Dumisani Dumisani 2, 25 25 silver badges 39 39 bronze badges. Fryann Martinez Fryann Martinez 3 3 silver badges 8 8 bronze badges.
Here's what I did to change the edit default to Go to Tools in top nav Select options, then SQL Service Object Explorer on left On right side of panel, click into the field that contains and change to or whatever number you wish Click OK and voila, you're all set!
Mayura Devani Mayura Devani 3 3 silver badges 16 16 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back
0コメント