Datatype in SQL Server7

Results 1 to 6 of 6

Thread: Datatype in SQL Server7

  1. #1
    Join Date
    Dec 1969

    Default Datatype in SQL Server7

    Is there a datatype in SQL7 which automatically generates decimals?<BR><BR>I.e if i insert 155 into PRICE column i automatically want it<BR>to be 155,00. If i insert 155,20 i would obsiusly just want to stick with that value...<BR><BR>Any help appreciated. I&#039;ve several types but none seems to do the job??<BR><BR>Regards / John

  2. #2
    Tim Snyder Guest

    Default RE: Datatype in SQL Server7

    SQL Server has money which is probably what you want

  3. #3
    Join Date
    Dec 1969

    Default not really ...

    Yes i can use money but when i&#039;m inserting values like<BR>155,50 it&#039;s automatically saved as155,5. This would leave me with one decimal. It&#039;s the same story with decimal(and numeric) datatypes. Region settings are swedish and will not be changed.<BR><BR>I don&#039;t want to use varchar or similiar.<BR><BR>Regards / john<BR>

  4. #4
    Tim Snyder Guest

    Default Display?

    Then what you are saying is the problem is display ?

  5. #5
    BAM Guest

    Default RE: not really ...

    Can you just use the formatcurrency function?

  6. #6
    Tim Snyder Guest

    Default Format


Posting Permissions

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