Professional Web Applications Themes

Specifying Numeric datatype in a SP - Microsoft SQL / MS SQL Server

i have a field named Corporate Amount the field is of datatype Numeric, size 5, precision 9, scale 2 how do i specify an input parameter in a stored procedure to handle the above at the minute i have it as follows:- CorpAmount as Numeric(5) but if i add the parameter via VB it drops the decimal placing i.e. the parameter from VB is datatype double of value 172.34 but when saved, it loses the .34 why Cheers, Craig...

  1. #1

    Default Specifying Numeric datatype in a SP

    i have a field named Corporate Amount

    the field is of datatype Numeric, size 5, precision 9, scale 2

    how do i specify an input parameter in a stored procedure to handle the
    above

    at the minute i have it as follows:-
    CorpAmount as Numeric(5)

    but if i add the parameter via VB it drops the decimal placing

    i.e. the parameter from VB is datatype double of value 172.34

    but when saved, it loses the .34

    why

    Cheers,
    Craig


    Craig Guest

  2. #2

    Default Re: Specifying Numeric datatype in a SP

    > the field is of datatype Numeric, size 5, precision 9, scale 2

    I don't know what "size 5" means. You don't dictate a size for a numeric
    column in SQL Server.
     

    Try

    CorpAmount AS NUMERIC(9, 2)


    Aaron Guest

  3. #3

    Default Re: Specifying Numeric datatype in a SP

    nice one, cheers for that

    Craig

    "Aaron Bertrand - MVP" <com> wrote in message
    news:phx.gbl... 
    >
    > I don't know what "size 5" means. You don't dictate a size for a numeric
    > column in SQL Server.

    >
    > Try
    >
    > CorpAmount AS NUMERIC(9, 2)
    >
    >[/ref]


    Craig Guest

Similar Threads

  1. ASP.NET Insert into bit datatype
    By RajDogLives in forum Adobe Dreamweaver & Contribute
    Replies: 9
    Last Post: May 20th, 04:45 PM
  2. citext datatype
    By Sim Zacks in forum PostgreSQL / PGSQL
    Replies: 0
    Last Post: January 2nd, 12:20 PM
  3. I think it's a datatype issue
    By Fox in forum ASP Database
    Replies: 11
    Last Post: January 7th, 09:01 PM
  4. Bit datatype
    By quixote in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 21st, 06:27 PM
  5. how to use userdefined datatype in UDF?
    By Rich in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 15th, 07:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139