Software Voices

Create proc sp_OutputMyIdent (@myOutputIdent int output)

as

set nocount on

Begin transaction 

    Insert myIdentTable Select 'foo'

    Select @myOutputIdent = @@Identity

rollback transaction

go

myCommand.CommandText = "sp_OutputMyIdent";

myCommand.CommandType = adCmdStoredProc;

myCommand.ActiveConnection = myConnection;        

myCommand.Parameters("@myOutputIdent") = 0;        

WScript.Echo("Before:  " + myCommand.Parameters("@myOutputIdent"));

myCommand.Execute();        

WScript.Echo("After:  " + myCommand.Parameters("@myOutputIdent"));

Before:  0

After:  1

Create proc sp_OutputMyIdent (@myOutputIdent int output)

as

set nocount on

Begin transaction 

    Insert myIdentTable Select 'foo'

    Select @myLocalVar = @@Identity

    RaisError ( N'Uh Oh!', 16, 1 )

rollback transaction 

go



try

{

myCommand.CommandText = "sp_OutputMyIdent";

myCommand.CommandType = adCmdStoredProc;

myCommand.ActiveConnection = myConnection;        

myCommand.Parameters("@myOutputIdent") = 0;        

WScript.Echo("Before:  " + myCommand.Parameters("@myOutputIdent"));

myCommand.Execute();

}

catch(e){ WScript.Echo(e.description) }

WScript.Echo("After: " + myCommand.Parameters("@myOutputIdent"));

Before:  0

Uh Oh!

After:  2

Create proc sp_OutputMyIdent (@myOutputIdent int output)

as

set nocount on

Declare @myLocalVar int

Begin transaction 

    Insert myIdentTable Select 'foo'

    Select @myLocalVar = @@Identity

    RaisError ( N'Uh Oh!', 16, 1 )

commit transaction 

Select @myOutputIdent = @myLocalVar

go