Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2009-05-11
5
Medium Priority
?
406 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 500 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
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

604 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