Re: Batch queries in stored procedures?

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 09:01:06 -0800

Addison Wesley Professional--same publisher as the Codd books. ;) 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message 
news:OCBJXGbHFHA.4060@TK2MSFTNGP14.phx.gbl...
> COOL !! Be lookin' fwd. to buyin' it !! :)  Who'se the publisher?
>
> - Sahil Malik
> http://codebetter.com/blogs/sahil.malik/
>
>
>
>
>
> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
> news:OB13T4THFHA.3072@tk2msftngp13.phx.gbl...
>> That's in the new book... (in progress).
>>
>> -- 
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> __________________________________
>>
>> "Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message
>> news:uMw8VPKHFHA.2456@TK2MSFTNGP09.phx.gbl...
>> > Yes you can do multiple resultsets via sprocs.
>> >
>> > Concurrency violation - I think you need to implement your own solution
>> > around this. A chapter could be written about this, lets start at "How
>> > have you implemented concurrency checks?"
>> >
>> >
>> > - Sahil Malik
>> > http://codebetter.com/blogs/sahil.malik/
>> >
>> >
>> > <Eric> wrote in message news:eBoFjv3GFHA.2360@TK2MSFTNGP12.phx.gbl...
>> >> I'm using SQL Server stored procedures to access my tables, but I'm
>> >> having
>> >> problems with concurrency violations when updating.
>> >>
>> >> The ADO.NET Core Reference (Ch. 11, pg 469) says you can use batch
>> >> queries
>> >> to retrieve data after submitting an update via a data adapter.  Am I
>> >> correct in assuming this same concept be applied to stored procedures?
>> >> If
>> >> so, a code example would be greatly appreciated.
>> >>
>> >> For reference, here are the steps I took so far:
>> >> - Set DataAdapter.UpdateCommand.UpdatedRowSource = FirstReturnedRecord
>> >> - Added code to stored procedure to SELECT the updated record.
>> >> - Added code to update the database:
>> >>    DataAdapter.Update(DataSet.DataTable.Select("", "", _
>> >>        DataViewRowState.ModifiedCurrent))
>> >>
>> >> Thank you,
>> >>
>> >> Eric
>> >>
>> >>
>> >
>> >
>>
>>
>
>

Relevant Pages