Solved

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

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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

747 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now