Inserting a Decimal - HELP

Im trying to insert a decimal into SQL 2000 using a stored procedure. I can successfully insert it using a direct T-SQL statement inside the code, but I cant insert it correctly when calling for a stored procedure.

For instance 12.5 will insert as 12.

Here is my SQL Parameter code:
[code]
MyCommand.Parameters.Add(New SqlParameter("@.Num", SqlDbType.Decimal))
MyCommand.Parameters("@.Num").Precision = 5
MyCommand.Parameters("@.Num").Scale = 2
MyCommand.Parameters("@.Num").Value = Convert.ToDecimal(TextBox1.Text)
[/code]

I also declared @.Num to be a decimal in my Stored Procedure.

As you can see I give the Parameter more than enough detail about the data type as well as convert the textbox value to a decimal, but it still rounds the value to an integer like data.

Again using a direct T-SQL statement inside the code works OK, but the stored procedure will not.
ANyone got any ideas why this is happening.Try running Profiler and tracing the transaction. Then you can determine if the precision is being lost when .NET sends the command to SQL Server, or when SQL Server calls the stored procedure. Have you tried not being so specific? Can you post the source code for your stored procedure?

MyCommand.Parameters.Add("@.Num", Convert.ToDecimal(TextBox1.Text))

Insert output of procedure inside table

Hello,
Can you tell me how can i put the output if the procedure sp_helpdb inside
one table?
Thanks and best regardsAnswered in thread: "RE: Insert output of sp_helpdb {dbname} in only one table"
"CC&JM" wrote:
> Hello,
> Can you tell me how can i put the output if the procedure sp_helpdb inside
> one table?
> Thanks and best regards

Insert output of procedure inside table

Hello,
Can you tell me how can i put the output if the procedure sp_helpdb inside
one table?
Thanks and best regards
Answered in thread: "RE: Insert output of sp_helpdb {dbname} in only one table"
"CC&JM" wrote:

> Hello,
> Can you tell me how can i put the output if the procedure sp_helpdb inside
> one table?
> Thanks and best regards

Insert output of procedure inside table

Hello,
Can you tell me how can i put the output if the procedure sp_helpdb inside
one table?
Thanks and best regardsAnswered in thread: "RE: Insert output of sp_helpdb {dbname} in only on
e table"
"CC&JM" wrote:

> Hello,
> Can you tell me how can i put the output if the procedure sp_helpdb inside
> one table?
> Thanks and best regards