The ability to create stored procedures is a useful aid for developers, but it is debatable whether production-level stored procedures will be written by using Server Explorer. In all probability, the required stored procedures will already exist on the database, and the database administrator will keep close control over who is allowed to create new stored procedures. | msdn training Module 3 Performing Connected Database Operations Contents Overview 1 Lesson Working in a Connected Environment 2 Lesson Building Command Objects 4 Lesson Executing Command Objects That Return a Single Value 17 Lesson Executing Commands That Return Rows 24 Lesson Executing Commands That Do Not Return Rows 35 Lesson Using Transactions 48 Review 57 Lab Performing Connected Database Operations 59 Microsoft Information in this document including URL and other Internet Web site references is subject to change without notice. Unless otherwise noted the example companies organizations products domain names e-mail addresses logos people places and events depicted herein are fictitious and no association with any real company organization product domain name e-mail address logo person places or events is intended or should be inferred. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright no part of this document may be reproduced stored in or introduced into a retrieval system or transmitted in any form or by any means electronic mechanical photocopying recording or otherwise or for any purpose without the express written permission of Microsoft Corporation. Microsoft may have patents patent applications trademarks copyrights or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft the furnishing of this document does not give you any license to these patents trademarks copyrights or other intellectual property. 2001-2002 Microsoft Corporation. All rights reserved. Microsoft MS-DOS Windows Windows NT Win32 Active Directory ActiveX BizTalk IntelliSense JScript MSDN SQL Server Visual Basic Visual C Visual C Visual J Visual Studio and Windows Media are either registered trademarks or trademarks of Microsoft Corporation in the . and or other countries. The names of actual companies and .
