In my VS 2005 windows control I am inserting a record into a table using a proc.
One of the fields "Accuracy" should look like this 66.4, but when I isnert it from the proc itlooks like 66.0. If I bypass my proc and use an inser statement from SQL quey analyzer it look like it should 66.4.
What am I doing wrong in my proc...
CREATE PROCEDURE [dbo].[insMyLameProc]
@.PlayerName nvarchar(255),
@.Score int,
@.Rounds int,
@.Accuracy decimal,
@.CorrectPicks int,
@.IncorrectPicks int
AS
--Insert the new game score
--===============================================================================================
insert into wmTurnTileScores
(PlayerName, Score, Rounds, Accuracy, CorrectPicks, IncorrectPicks)
values (@.PlayerName, @.Score, @.Rounds, @.Accuracy, @.CorrectPicks, @.IncorrectPicks)
--===============================================================================================
GO
@.Accuracy decimal(18,2)
--The 2 gives it 2 decimal places.
|||
rpack79:
@.Accuracy decimal(18,2)
--The 2 gives it 2 decimal places.
This is right, but as a tip: don't use the 18 if you are sure you will not need it. (faster query + save space).
Good luck.
|||Yup, that worked, thanks
