Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Something's wrong with numeric data
Message
 
 
À
05/03/2003 10:15:43
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00761481
Message ID:
00761497
Vues:
49
>Works for me. Did you added the column after the fact?
>
>What's your column definition? (Create Table syntax)
/****** Object:  Table [dbo].[TaxRates]    Script Date: 3/5/2003 10:28:01 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TaxRates]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TaxRates]
GO

/****** Object:  Table [dbo].[TaxRates]    Script Date: 3/5/2003 10:28:06 AM ******/
CREATE TABLE [dbo].[TaxRates] (
	[State] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[FullStateName] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[TaxRate] [numeric](2, 0) NOT NULL 
) ON [PRIMARY]
GO
I see the problem. It should be 5,2 instead of 2.0 That's my problem. How should I do it table designer?

BTW, the thread title should say data, not date. I appologize.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform