Professional Web Applications Themes

DATA TYPE! - ASP Database

For web application development what is the prefered datatype for storing dollar amounts in SQL Server 2000. decimal : smallmoney ??...

  1. #1

    Default DATA TYPE!

    For web application development what is the prefered datatype for storing
    dollar amounts in SQL Server 2000.
    decimal : smallmoney ??


    Anthony Guest

  2. #2

    Default Re: DATA TYPE!

    Anthony Judd wrote: 

    There's really no hard-and-fast rule. It depends on what you are using it
    for, and what amount of precision is needed. There is an article in Books
    Online (in your SQL Server program group) that talks about the various
    datatypes. Actually there are several. Type "money" into te index and start
    with the Overview subtopic.

    Bob Barrows
    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Guest

  3. #3

    Default Re: DATA TYPE!

    Thanx for the reply Bob!!!!

    I am aware of the different datataype available in sql server.
    Mostly my question is what other people prefer to use.

    My sql server development is fairly sheltered, i don't have anyone who i can
    share ideas with, and learn from.
    So i am just checking to see if i am making any bad design choices on my
    own.

    AJ



    Anthony Guest

Similar Threads

  1. Converting from data type varchar to data type money
    By schaudry in forum Coldfusion - Advanced Techniques
    Replies: 6
    Last Post: June 10th, 11:01 PM
  2. Converting data type varchar to data type money
    By schaudry in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: June 10th, 07:22 PM
  3. retriving data from memo data type of msaccess to asp.net
    By Aneesh a in forum ASP.NET Web Services
    Replies: 0
    Last Post: May 7th, 01:11 AM
  4. Replies: 3
    Last Post: October 18th, 06:56 AM
  5. Replies: 2
    Last Post: October 16th, 08:29 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