Torna al Thread

CREATE TABLE [T_VALORI_AGGR]( [SYS_USER] [varchar](25) NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_SYS_USER] DEFAULT (''), [SYS_DATA_AGGIOR] [datetime] NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_SYS_DATA_AGGIOR] DEFAULT (getdate()), [FK_ID_UTENTE] [char](5) NOT NULL, [FK_ID_AGGR] [int] NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_FK_ID_AGGR] DEFAULT ((0)), [FK_ID_PAESI_VALUTE] [smallint] NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_FK_ID_PAESI_VALUTE] DEFAULT ((0)), [FK_MESE] [smallint] NOT NULL, [FK_ANNO] [smallint] NOT NULL, [T] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_T] DEFAULT ((0)), [T12] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_T06] DEFAULT ((0)), [T24] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_T12] DEFAULT ((0)), CONSTRAINT PK_T_VALORI_AGGR PRIMARY KEY ([FK_ID_UTENTE],[FK_ID_AGGR],[FK_ID_PAESI_VALUTE],[FK_MESE],[FK_ANNO]) ) ON PARTITIONS_PART_PScheme (FK_ID_UTENTE)
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5