Wednesday, 25 May 2011

How to Share Data Between Stored Procedures


How to Share Data Between Stored Procedures
http://www.sommarskog.se/share_data.html


  • Using OUTPUT Parameters
  • Table-valued User-defined Functions
  • Using a Table
  • Insert-Exec
  • Table Parameters, and Table Types
  • Using the CLR
  • OPENQUERY
  • Using XML
  • Using Cursor Variables

    A must read.
  • No comments:

    Post a Comment