SQL Server Management Studio

SQL Server Management Studio

am 16.04.2008 07:47:38 von maloney1

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

Re: SQL Server Management Studio

am 16.04.2008 09:42:14 von ivce970

On Apr 15, 10:47 pm, maloney1 wrote:
> 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 !

Re: SQL Server Management Studio

am 17.04.2008 00:06:13 von maloney1

On Apr 16, 1:42=A0am, Ivan Delic wrote:
> On Apr 15, 10:47 pm, maloney1 wrote:
>
> > 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?