Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text

Links

XODOX
Impressum

#1: SQL Server Management Studio

Posted on 2008-04-16 07:47:38 by 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

Report this message

#2: Re: SQL Server Management Studio

Posted on 2008-04-16 09:42:14 by ivce970

On Apr 15, 10:47 pm, maloney1 <malon...@gmail.com> 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 !

Report this message

#3: Re: SQL Server Management Studio

Posted on 2008-04-17 00:06:13 by maloney1

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

Report this message