<div>
a procedure to &quot;return&quot; a single variable is written like this:<br />

<pre><code id="code-257622">CREATE PROCEDURE SP_A 
( @result VARCHAR(100) OUTPUT
)
AS
BEGIN
  SELECT @result = somecolumn FROM sometable WHERE &lt;some condition goes here&gt;
END</code></pre>
</div>


a procedure to "return" a single variable is written like this:


CREATE PROCEDURE SP_A 
( @result VARCHAR(100) OUTPUT
)
AS
BEGIN
  SELECT @result = somecolumn FROM sometable WHERE <some condition goes here>
END

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
There are 2 MSSQL stored procedures:<br />
SP_A which will select a field from a table and return it. <br />
SP_B which needs to declare a variable and the return value from SP_A will be assigned to it<br />
<br />
How can I write those 2 stored procedures? <br />
and, the SP_B need to write transaction to ensure commit otherwise rollback. <br />
<br />
Is there any full source code example?
</div>
</div>


Hi

There are 2 MSSQL stored procedures:
SP_A which will select a field from a table and return it. 
SP_B which needs to declare a variable and the return value from SP_A will be assigned to it

How can I write those 2 stored procedures? 
and, the SP_B need to write transaction to ensure commit otherwise rollback. 

Is there any full source code example?

How to write a return value in a SP and how another SP get the return value from that SP?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.