Solved

Just open the table and be able to edit any/all rows in an SQL database

Posted on 2009-05-11
5
390 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:Rickhdee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 21

Expert Comment

by:JestersGrind
ID: 24356009
Right-click on the table in Management Studio and select Open Table.

Greg


0
 

Author Comment

by:Rickhdee
ID: 24356449
I do not see the OPEN TABLE option after right-clicking.  This is SQL 2008.
0
 
LVL 21

Accepted Solution

by:
JestersGrind earned 125 total points
ID: 24356724
Sorry, I missed that you wrote SQL 2008.  You want to use Edit Top 200 Rows for the same functionality.  If you want to see more than 200, click on the little SQL button on the toolbar.  This should bring up the query pane.  Just remove "TOP (200)" and click on the exclamation point to run it again.

Greg


0
 

Author Closing Comment

by:Rickhdee
ID: 31580208
Thanks Greg, it works.  Still curious though, the query shows simply as "select" no edit keywords.  Looks just like a standard select statment with nothing to indicate it is doing an update.  It does however allow me to do what I need to do.
0
 
LVL 21

Expert Comment

by:JestersGrind
ID: 24357865
You're right.  It is just a select statement.  It's basically a filter for what will be shown in the lower pane for editing.  I prefer using T-SQL for doing these types of tasks, but it's not bad for a quick and dirty update.

Greg


0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question