Just open the table and be able to edit any/all rows in an SQL database
Posted on 2009-05-11
When you use the "Select top 1000" command in Sql Server 2008 it generates a script that you can actually modify. However, the "Edit Top 200" command does seem to generate a script. Basically I want to be able simply and easily open any table in an edit mode that will allow access to all rows and edit any data. For example, in Access or Visual Foxpro, I can simply click on the table. It opens and I can do a search for a given value and edit the data. I know this is very basic stuff, but I am on a deadline and just looking for a quick and easy way to be able to access data and make quick changes.