Decimal values...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Kevin Lisboa (Kevin.Lisboa_at_onsemi.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 06:53:57 -0800

Using STS 1.0 with SQL Server 2000 in the back end. One
of the user groups is requesting a numeric field that
uses multiple decimal values. Much like chapters in an
old school book:

1.0
1.1
1.1.01
1.1.02
1.1.03
1.2
1.2.01

And so on. What's the best Data Type value I can select
in the SQL Server Database to allow this to be entered?

Thanks for the help...
Kevin

Relevant Pages

  • vinculated table from sqql server200 into access 97, problem with numeric data
    ... I have a table in Sql Server 2000 with a numeric field, actually float. ... Luis Aguayo ...
    (microsoft.public.access.externaldata)
  • which sqlcedatareader method should I call for a numeric field?
    ... I am developing a sql server 2005 ce appliaction. ... So I am confusing... ... Which other method should I call for numeric field than ...
    (microsoft.public.sqlserver.programming)
  • dbo issues
    ... Our security in SQL Server is governed by User Groups in Wind2K. ... with their group account name login instead of dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2000 NETWORKIO issues
    ... Most Network IO waits are caused by the client (who ever is actually talking ... to SQL Server and requesting the rows) not being able to handle the rows ... In this case it sounds like the web service gets hung ... application users to a SQL Server 2000 database with service pack 4. ...
    (microsoft.public.sqlserver.connect)
  • Re: CE8 & "NT AUTHORITYSYSTEM" User.
    ... My SQL Server view ... needs to know the name of the user that is requesting the data inorder ... SQL Server's niladic function SYSTEM_USER returns the name ... I have implemented a temporary solution where the report points ...
    (microsoft.public.vb.crystal)