my $mssql = 'DECLARE @RetVal as Int; INSERT INTO TableC ( [ID], [Amount]) VALUES ( 236, 136400); Set @RetVal = SCOPE_IDENTITY(); Select @RetVal as RETURNVALUE;';
my $sth = $msdataconn->prepare($mssql);

LogMsg(7, "Executing $mssql");
my $error = $sth->execute();

my @values = $sth->fetchrow_array;
$recIDInsurance = $values[0] if defined($values[0]);

if ($msdataconn->errstr) {
     LogMsg(0, $error);
     LogMsg(0, $msdataconn->errstr);

# do some stuff
}