Help Edit Query

  • uknites

    SSC Veteran

    Points: 255

    Dear All:

    I want to run a query on the remote SQL server via SQL Management Studio where I want to view the data in the table and modify entries in the table.

    I can do it by using edit top 200 rows option but I want to know how I will do it directly via Query so that it shows me the contents of the entire table where I can modify the records

    I want to view and edit the attendance of all staff in the table called ATTN

    Thanks

  • Thom A

    SSC Guru

    Points: 98644

    uknites wrote:

    I want to know how I will do it directly via Query so that it shows me the contents of the entire table where I can modify the records

    You don't. The Edit Top 200 Rows is an awful feature. If you want to update your data, do it properly and use UPDATE statements. SQL Server isn't Microsoft Access; you don't update in in data grids, you use SQL Statements to manipulate the data stored in the tables.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • ktflash

    Ten Centuries

    Points: 1134

    It is possible to increase the number of rows available in the Editor Window, but as Thom suggests, the Update Command is the way to go

    I want to be the very best
    Like no one ever was

  • Jonathan AC Roberts

    SSCoach

    Points: 17298

    If you go into menu item Tools/Options, you can change the value from 200 to a different number:

    Capture3

    Or if you click the "SQL" button once you have selected the rows, then you can edit the query from SELECT TOP(200) to a different number.

    Capture4

  • Med Anwar

    SSC Enthusiast

    Points: 142

    It's bad idea but you can do "edit top 200 rows" to display your grid then switch to sql script (shortcut by default Ctrl+3) remove TOP (200) and execure your querry.

    switch200

    • This reply was modified 8 months, 2 weeks ago by  Med Anwar.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply