By Aaron Young - 3/26/2009
Hi,
Just noticed a problem with decimals during data deployment. I have a simple VERSION table defined as follows:-
Field Name Field Type
NAME VarChar(40) - primary key
VALUE Decimal(10,2)
I have created a data deployment package set to overwrite and have noticed that the deployment stored procedure which is created doesn't support decimal places in the VALUE field. The stored procedure definition is:-
CREATE PROCEDURE VERSIONInsertOverwrite @NAME as VarChar(40), @VALUE as Decimal AS BEGIN DELETE FROM VERSION WHERE NAME = @NAME INSERT INTO VERSION (NAME, VALUE) VALUES (@NAME, @VALUE) END
When the procedure is executed as follows, it drops the decimal places:-
exec VERSIONInsertOverwrite @NAME='Database',@VALUE=10.01
The above code stores a value of 10 instead of 10.01
Just to confirm, the VALUE field is definitely defined as 10.2 and can store a value of 10.01 through an update statement.
Aaron
|
By Trent L. Taylor - 3/27/2009
I will set this up and see if I can reproduce. Thanks.
|
|