mySqlCommand.Parameters.Add(New Data.SqlClient.SqlParameter("@RecordCount", Data.SqlDbType.Int))
            mySqlCommand.Parameters("@RecordCount").Direction = Data.ParameterDirection.Output
            mySqlCommand.CommandType = Data.CommandType.StoredProcedure
            mySqlCommand.CommandText = ("sp_ZyTax_Get_Record_Count_jTable")
            mySqlCommand.Connection = mySqlConnection
            mySqlCommand.ExecuteScalar()
            Return myRecordCount = mySqlCommand.Parameters("@RecordCount").Value

@RecordCount int output

as

BEGIN 
    set nocount on 
    select count(*) from ZyTax.dbo.jTable
    set @RecordCount = @@ROWCOUNT 
END 
GO

@RecordCount int output

as

BEGIN 
    set nocount on 
    declare @Records as int
    select @Records = count(*) from ZyTax.dbo.jTable
    set @RecordCount = @Records
END 

declare @myRowcount int
exec sp_ZyTax_Get_Record_Count_jTable @RecordCount = @myRowcount output
select @myRowcount [@myRowcount_out]