<div>
Well, the requirement would be to be able to work with numbers greater than 2147483648. this is the maximum values that an integer can hold. Numeric(32,0) gives you flexibility to actually have an integer far greater than what you could get using an Int
</div>


Well, the requirement would be to be able to work with numbers greater than 2147483648. this is the maximum values that an integer can hold. Numeric(32,0) gives you flexibility to actually have an integer far greater than what you could get using an Int

<div>
you should be able to send an integer to the proc without problems. &nbsp;If the parameter can only be 1,2,3 or 4 then they temporarily wasted a few bytes, but it is unlikely to be noticeable.
</div>


you should be able to send an integer to the proc without problems.  If the parameter can only be 1,2,3 or 4 then they temporarily wasted a few bytes, but it is unlikely to be noticeable.

<div>
&quot;In what form should I input the data&quot;<br />
<br />
How are you using this? &nbsp;Typing it into a query window of SSMS? &nbsp;Dynamic Sql via an ODBC connection? &nbsp;Parameterized ADO call?
</div>


"In what form should I input the data"

How are you using this?  Typing it into a query window of SSMS?  Dynamic Sql via an ODBC connection?  Parameterized ADO call?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to use a stored procedure that has a parameter called ‘Option’ of type:<br />
<br />
Numeric(32,0)<br />
<br />
In what form should I input the data. &nbsp;I know that valid options are<br />
<br />
1<br />
2<br />
3<br />
4<br />
<br />
But I can’t understand why this is simply not an int parameter?<br />
<br />
Thanks.
</div>
</div>


Hi,

I need to use a stored procedure that has a parameter called ‘Option’ of type:

Numeric(32,0)

In what form should I input the data.  I know that valid options are

1
2
3
4

But I can’t understand why this is simply not an int parameter?

Thanks.

SP – Parameter type Numeric(32, 0)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.