Bloggs
 
 
    Help :: Bloggs

Small Business Web Site Design Brisbane, Australia
 How to Use  

Welcome to my Bloggs and ravings on .NET Web design and IT consultancy.  If you would like to participate in these discussions your welcome.  Simple register with the site and we will send you a confirmation email with a code to allow you to log in.  When you log in the code is required to verify your email address.  Then you can make comment on any articles written.  Thankyou for your participation! 

   
 Print   
 Blog List  
   
 Print   
 Search NewBlog  
   
 Print   
 SQL Server  
Location: BlogsGeneral DiaryMicrosoft .NET Application Development    
Posted by: Conrad Woolston Thursday, September 21, 2006
How to use SQL SERVER

Returning Data from a Stored Procedure

Microsoft® SQL Server™ 2000 stored procedures return data in four forms:

  • Output parameters, which can return either data (such as an integer or character value) or a cursor variable (cursors are result sets that can be retrieved one row at a time).

  • Return codes, which are always an integer value.

  • A result set for each SELECT statement contained in the stored procedure or any other stored procedures called by the stored procedure. For more information about using the SELECT statement, see Query Fundamentals.

  • A global cursor that can be referenced outside the stored procedure. For more information about using cursor variables, see Scope of Transact-SQL Cursor Names.
Copyright ©2006 Conrad Woolston
Permalink |  Trackback

Your name:
Title:
Comment:
Add Comment   Cancel 
   
  

Website Design Brisbane*Web Design Brisbane
FAQ|Articles |Free_Tools|Free Chat|Bloggs
 
Register             Login   
  
Copyright 2005 WhyNotWebSites.com