Clever Geek Handbook

Is there a SQL editor for the data itself?

I am looking for a SQL tool (MSSQL) that will allow me to edit / insert / etc. data without the need to enter sql statements. I just want to enter data into the grid. I cannot find this feature in SSMS. Is there any tool out there that does this (MS preferably)?

+3


source to share


6 answers


Table editor

If you right click on the table in SSMS and click Edit, you can directly edit the data there.

Table Editor



Query constructor

If you select a row or cell in the table editor, you have access to the query designer menu on the toolbar. Clicking on the panel menu will open a submenu that will give you access to SQL, criteria and chart. This will allow you to visually design queries.

Query Designer

+4


source


SSMS lets you do this, although it's not a great tool for any stretching. If you right click on the table and go to Edit Top 100 rows, you can get the grid. If you want to edit any number of rows, go to Tools → Options → SQL Server Object Explorer → Commands and change both the values ​​in the Table and View options to "0" which means unlimited.



You can also edit the query that is used to create the mesh. There is a button on the toolbar that says SQL and hovertext: "Show SQL Bar". Then you can edit the SQL to include / exclude columns or add conditions. This can help with large tables. You can also use this method to overcome the row limit if you haven't changed the defaults as in the paragraph above.

+3


source


Right-click the table in SSMS and select Edit Top 200's Rows: .

+2


source


Using MS SQL Managment Studio, you can right click on the table and select Modify. This will allow you to edit existing lines and add new lines by simply entering a "grid".

0


source


try it. maybe it can help

http://www.toadworld.com/platforms/sql-server/w/wiki/10392.editing-an-sql-server-table-in-excel.aspx

0


source


The real easy thing is to use Access as the front-end for SQL Server. It only takes a few minutes to create an ODBC connection from Access to SQL Server, and you can quickly use access grids and forms to enter data.

0


source






More articles:


All Articles