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
Solved

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

Posted on 2009-05-11
5
386 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
  • 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

828 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