Grid-based editing for SQL Server
I was wondering if there were a grid-ba开发者_开发知识库sed editor for SQL Server that simply let you work within a spreadsheet-type interface and key information directly into the sheet (like Access used to let you).
I need something quick to use when I'm creating test data, and considering I have about 9 other jobs to do at once, this seemed like the best bet..
SQL Server Management Studio Express
- Connect to a database from the Object Explorer.
- Expand the database node
- Expand the Tables node
- Right click the table and click Edit
- Type in the values you want
- When you navigate away from the row, the data is committed
SQL Management Studio can edit rows. Just right click on the table in the list of database objects and click Edit Top 200 Rows.. And SQL Management Studio Express is free. http://msdn.microsoft.com/en-us/library/ms365247.aspx
Your best bet is to expand the tree in SSMS to
Server \ Databases \ Tables \ <target table>
Right-click on the table, choose "Edit top 200 rows"
You can then use the grid to add/edit data. If you need to work with another range, right click on the grid, Pane > SQL - edit the statement to bring in the range desired. Note however that the query must still be able to uniquely identify the source row for the grid to remain editable.
You can also get it to be more Access like by right-clicking and choosing Pane > Criteria
.
精彩评论