Nate Nate - 1 year ago 189
SQL Question

Sql Server out on parameter

What does out mean on a stored procedure?

Create Procedure [schema].[proc_Name]
@valueone int out
As
Begin
Update [Table] set Value = @valueone
end

Answer Source

Nothing (in this particular case)

Otherwise it is an output parameter as you probably suspected. So if you change the value of @valueone inside the stored proc, that value will be returned to the caller.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download