• Have a look at this, I think it will answer your questions:

    http://blogs.msdn.com/b/mattm/archive/2006/11/08/stored-procedures-with-output-parameters.aspx[\url]