<div>
in order to assign the value <br />
<br />
SELECT @myVariable = NULL
</div>


in order to assign the value

SELECT @myVariable = NULL

<div>
So simple! &nbsp;I should have asked sooner. &nbsp;Not sure why I couldn't find it in all my books and Googling.<br />
<br />
Thanks,<br />
<br />
Todd
</div>


So simple!  I should have asked sooner.  Not sure why I couldn't find it in all my books and Googling.

Thanks,

Todd

<div>
<div class="content wysiwyg-content">
Is there a way to have a variable in a stored procedure that is not an input variable? &nbsp;I just need it for use inside my stored procedure but when I set it up like this<br />
<br />
&nbsp; &nbsp; &nbsp;@MyVariable varchar(50)<br />
<br />
it shows up as an input when the stored procedure is run from Management Studio. &nbsp;I tried this<br />
<br />
&nbsp; &nbsp; &nbsp;@MyVariable varchar(50) = Null<br />
<br />
which then allows the user to start the stored procedure without entering a value for the varible but I don't want it to show up at all. &nbsp;It just needs to be there for internal use only.<br />
<br />
Thanks,<br />
<br />
Todd
</div>
</div>


Is there a way to have a variable in a stored procedure that is not an input variable?  I just need it for use inside my stored procedure but when I set it up like this

     @MyVariable varchar(50)

it shows up as an input when the stored procedure is run from Management Studio.  I tried this

     @MyVariable varchar(50) = Null

which then allows the user to start the stored procedure without entering a value for the varible but I don't want it to show up at all.  It just needs to be there for internal use only.

Thanks,

Todd

Can I setup an internal variable in a stored procedure?

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.