Edit Table (Sql 2008)

Posted on 2009-04-21
Medium Priority
Last Modified: 2012-05-06
In Object Explorer you can right click on a table and select Edit Top 200 Rows.  When you do it opens the table in Edit Mode.

Does anyone know the syntax of how to write that in a query so you do not have to right click and select Edit Top 200 Rows?

Question by:Sreedhar Vengala
  • 2
LVL 27

Accepted Solution

Chris Luttrell earned 750 total points
ID: 24200900
As far as I have ever seen you can't launch the Edit grid from a query window, it's just part of their GUI.   That would be cool if you could.  The sql behind the grid is just Select TOP(200) ... from Table.  Maybe if we are both lucky someone knows the secret, but I've been doing this a while on a daily basis and have not run across it.

Author Comment

by:Sreedhar Vengala
ID: 24200923
You can still change 200 to Custom No. of Rows
Tools > Options >SQL Server Object Explorer > Commands > Table and View Options.
LVL 27

Expert Comment

by:Chris Luttrell
ID: 24200988
Yes, but thats the extent of what you can mess with.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

621 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