Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

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.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

773 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