Edit Table (Sql 2008)

Posted on 2009-04-21
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
    LVL 26

    Accepted Solution

    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.
    LVL 9

    Author Comment

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

    Expert Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 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

    21 Experts available now in Live!

    Get 1:1 Help Now