SP – Parameter type Numeric(32, 0)

Posted on 2012-09-18
Last Modified: 2012-10-04

I need to use a stored procedure that has a parameter called ‘Option’ of type:


In what form should I input the data.  I know that valid options are


But I can’t understand why this is simply not an int parameter?

Question by:andyw27
    LVL 67

    Accepted Solution

    No clue either. Numeric(32,0) is the same as Decimal(32,0), and represents a number holding exactly 32 decimal digits. Usually you see such when converting from Oracle, but indeed it does not make sense for values that low. A smallint would suffice, or an int. Even a bigint has approximately 15 decimal digits only ...
    LVL 5

    Expert Comment

    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
    LVL 18

    Expert Comment

    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.
    LVL 21

    Expert Comment

    "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?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how the fundamental information of how to create a table.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now