search

pepeamoros / MECEMSA.RectificativaOT

0 stars 0 forks source link

Alb_IdAlbaranesRectifica #7

Open pepeamoros opened 8 years ago

pepeamoros commented 8 years ago

Nueva Tabla: USE [CONTA] GO CREATE TABLE [dbo].[Alb_IdAlbaranesRectifica]([NumOrdenT] [int] NOT NULL, [IDAlbaran] [char]%2820%29 NOT NULL, [IDAlbaranR] [char]%2820%29 NULL, [Fecha] [datetime] NULL, [Empresa] [char]%282%29 NULL, [IDFactura] [varchar]%2820%29 NULL, [IDFacturaR] [varchar]%2820%29 NULL, [IDProceso] [varchar]%2850%29 NULL, CONSTRAINT [PK_Alb_IdAlbaranesRectifica] PRIMARY KEY CLUSTERED %28 [NumOrdenT] ASC, [IDAlbaran] ASC %29WITH %28PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80%29 ON [PRIMARY]) ON [PRIMARY]

pepeamoros commented 8 years ago

Añadir el idProceso (Varchar(50) newid()