[dba-SQLServer] Multiple Updates In One Stored Procedure

I think Paul asks, because in BOL you find a lot of examples w/ the GO 
keyword aftwards... I think it would help him a lot if he picked up a good 
Stored Procedures book. Altho BOL do seem very through.

http://www.amazon.com/exec/obidos/tg/detail/-/0072228962/qid=1117667473/sr=8-1/ref=sr_8_xs_ap_i1_xgl14/002-8508889-5196029?v=glance&s=books&n=507846



On 6/17/05, Jim Lawrence <accessd at shaw.ca> wrote:
> 
> Hi Paul:
> 
> There is ways in many cases ways around using the 'GO' but it is a good 
> way
> to separate the sections. This seems like an odd question.(?)
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul
> Hartland
> Sent: Friday, June 17, 2005 1:35 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] Multiple Updates In One Stored Procedure
> 
> To all,
> 
> If I want to create a Stored Procedure that updates multiple tables, do
> I have to have the word GO after each update section ?
> 
> Thanks in advance for any help..
> 
> 
> PAUL HARTLAND
> Database Designer/Programmer
> paul.hartland at isharp.co.uk
> ISHARP
> DDI - 01922 472031
> Mobile - 07730 523179
> 
> 
> 
> _______________________________________________
> 
> * This message is confidential.
> * This email, its content and any files transmitted with it are intended
> solely for the addressee and may be legally privileged and/or 
> confidential.
> * Access by any other party is unauthorised without the express written
> permission of the sender.
> * If you have received this email in error you may not copy or use the
> contents, attachments or information in any way and any review, use,
> dissemination, forwarding, disclosure, alteration, printing of this
> information is strictly prohibited. Please destroy it and notify the 
> sender
> via return e-mail.
> * This email has been prepared using information believed by Paul Hartland
> to be reliable and accurate, but the company makes no warranty as to
> accuracy or completeness. In particular the author does not accept
> responsibility for changes made to this email after it was sent.
> * Any opinions expressed in this document are those of the author and do
> not necessarily reflect the opinions of the company or its affiliates.
> 
> The Orridge web site can be found at:
> http://www.orridge.co.uk
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...