[dba-SQLServer] Multiple Updates In One Stored Procedure

The true reason I ask is because I am passing the procedure two
parameters, and after the first GO keyword it loses the parameters, but
when I tried with just GO at the very end it worked fine.  Yet in many
examples I have seen they have had GO after each Update/Insert 


PAUL HARTLAND
Database Designer/Programmer
paul.hartland at isharp.co.uk
ISHARP
DDI - 01922 472031
Mobile - 07730 523179

 

ISHARP (Information Services for Hospitality, Audit, Retail and
Pharmacy) provide IT resources for the Christie Group Stock & Inventory
Services companies.


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
Francisco Tapia
Sent: 17 June 2005 17:29
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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=50
7846



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...
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com