开发者

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

  1. Connect to a database from the Object Explorer.
  2. Expand the database node
  3. Expand the Tables node
  4. Right click the table and click Edit
  5. Type in the values you want
  6. 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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜