Even if you have a tool like Redgate SQLPrompt installed, it will not work in this designer. One disadvantage though: there’s no autocomplete, no intellisense, nothing. You can remove the top 200 clause, sort the data, remove columns, you name it. You can edit the query to suit your needs. But what I’m really after is the little SQL button, which will just show you the actual query: If you click the second button, you get the full query designer:Īside from deselecting columns, you can now also filter and sort columns. But this view let’s you easily deselect columns to get a less cluttered view. Just like in the graphical query and view designer (please do not ever use this, it creates abominations of queries). When you click the left button, you’ll see a diagram of the table: In the toolbar, you have the following buttons (screenshot taken with SSMS 18.4): What if you can’t find the row you want to modify? Luckily, you can adapt the SQL query that fetches those 200 rows. You’ll be taken to a grid where you can modify the value of each cell.īut you only have access to 200 rows. In SSMS, you can do this by right-clicking the table and selecting “Edit top 200 rows”. For example, in the development environment you want to modify a value in a column to test out a scenario, or you are creating a table with some dummy data. Sometimes you directly want to manipulate data without having to write a SQL statement. A quick blog post on a SSMS trick: how to quickly edit data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |