SQL Server Management Studio

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • maloney1
    #1

    SQL Server Management Studio

    Hello all,

    I have SQL Server Mgmt Studio and would like to know how to shut off
    the auto updates that occur when you leave a modified row in the "Open
    Table" view of a table? I want to update several rows at a time and
    then send all modified rows back for an update.

    Thanks
    J Maloney
    Tags: None
    • Ivan Delic
      #2
      Re: SQL Server Management Studio

      On Apr 15, 10:47 pm, maloney1 <malon...@gmail .comwrote:
      Hello all,
      >
      I have SQL Server Mgmt Studio and would like to know how to shut off
      the auto updates that occur when you leave a modified row in the "Open
      Table" view of a table? I want to update several rows at a time and
      then send all modified rows back for an update.
      >
      Thanks
      J Maloney
      Well, J.

      I think that all you need to do is to click Execute SQL on Query
      Designer meny, and your table or view will be updated.

      Other view is to click on red mark !

        Comment

        • maloney1
          #3
          Re: SQL Server Management Studio

          On Apr 16, 1:42 am, Ivan Delic <ivce...@gmail. comwrote:
          On Apr 15, 10:47 pm, maloney1 <malon...@gmail .comwrote:
          >
          Hello all,
          >
          I have SQL Server Mgmt Studio and would like to know how to shut off
          the auto updates that occur when you leave a modified row in the "Open
          Table" view of a table? I want to update several rows at a time and
          then send all modified rows back for an update.
          >
          Thanks
          J Maloney
          >
          Well, J.
          >
          I think that all you need to do is to click Execute SQL on Query
          Designer meny, and your table or view will be updated.
          >
          Other view is to click on red mark !
          What I want to do is let the red exclamation points show for several
          rows without SQL Manager sending the Execute update each time I leave
          a row. I would guess it would be a setting that would wait to commit
          changes until I tell it to rather than when I leave an edited row. I
          don't know if anyone has worked with Toad for Oracle, but it has a
          Commit button that iterates all your changed rows and updates them
          when you tell it to. Any idea if there is a setting for this in Sql
          mgmt studio?

            Comment

            Previous template Next
            Working...