Variable as numeric sent to stored procedure (SQL Server 2005)
Posted
by TimCarrett
on Stack Overflow
See other posts from Stack Overflow
or by TimCarrett
Published on 2010-04-09T13:24:39Z
Indexed on
2010/04/09
13:33 UTC
Read the original article
Hit count: 350
I see that with SQL Server 2005 you can pass a parameter as numeric e.g.
create procedure dbo.TestSP
@Param1 numeric
as
But what does this equate to? E.g. Numeric(10,0), Numeric(9,2), etc? We have some Developers here who are using this instead of the correct definition for the field that this parameter is going to be used against e.g. instead of using Numeric(10, 0) for the parameter @Param1.
Also are there any underlying performance issues with using Numeric instead of the data type defined against the field in the table?
Many thanks.
© Stack Overflow or respective owner
