How to alter SQL in "Edit Top 200 Rows" in SSMS 2008
In SQL Server 2008 Management Studio, when I right click on a database table and choose Select Top 100 Rows, I can then e.g. easily add a ORDER BY statement to the SQL. That works fine.
But when I do choose Edit Top 200 Rows, I don't have the ability to alter the SQL (which makes it hard to find and edit a record just added in the 10,000 that are there.
I am quite sure I was able to do this in SQL Server 2000.
Is there any way in SMSS 2008 to alter the way the records are displayed when editing records?
If you right click on any result of "Edit Top 200 Rows" query in SSMS you will see the option "Pane -> SQL". It then shows the SQL Query that was run, which you can edit as you wish.
It's the SQL button on the following image:
In SMSS 2012 and 2008, you can use Ctrl+3 to quickly get there.
- No column name was specified for column 1 of 'sp'
- Getting only Month and Year from SQL DATE
- T-SQL multiple COUNT() with JOIN and LEFT JOIN
- Can't remove single Quote in SQL
- How do I get matched pairs of results (1 male and 1 female) with the same age at random?
- SQL Server Operating system error 5: "5(Access is denied.)"
- How to get the 30 days before date from today's date
- How to get the date 30 days before today's date from database
- What are the disadvantages to Indexes in database tables?
- Default parameter in SQL where clause
- How can I filter words in SQL using a function?
- Getting the second occurrence from charindex function in sql server
- How can I add a database reference to another database on the same server without a .dacpac, so Visual Studio recognizes cross-database reference?
- Connecting to a SQL Server database running in a Docker container from another docker container
- How to connect to SQL Server docker container from another container?
- Unable to enable Microsoft Change Data Capture (CDC) sp_cdc_enable_db
- Crosstab in SQL Server with a column that may have no data
- IIS Regional Settings
- MS Access error "ODBC--call failed. Invalid character value for cast specification (#0)"
- Multiple select queries with union, flatten to single row
- How to access my database from another server
- Highlight Duplicate Values in a NetSuite Saved Search
- Unique constraint on multiple columns in a table variable
- Get size of all tables in database
- SSRS- How can I eliminate page breaks within an email body?
- Performing a bitwise sum
- Creating a balance statement
- One Index, Two Indexers, Populate Array
- SQL Selecting if "active" = true
- Automatically deleting old log entries with the Serilog mssqlserver sink?