Tema: no se porque no me guarda el ultimo valor, insert into sql server 2005
Ver Mensaje Individual
  #15 (permalink)  
Antiguo 21/05/2010, 08:10
porygon_humano
 
Fecha de Ingreso: abril-2009
Ubicación: Bogota
Mensajes: 217
Antigüedad: 15 años
Puntos: 1
Respuesta: no se porque no me guarda el ultimo valor, insert into sql server 2005
este es el scrip de la tabla

USE [DATABASE1]
GO
/****** Object: Table [dbo].[PERSONA] Script Date: 05/21/2010 09:04:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PERSONA](
[TX_AUTO_PERS] [nvarchar](18) COLLATE Modern_Spanish_CI_AS NOT NULL,
[TX_AUTO_TIDO_PERS] [nvarchar](18) COLLATE Modern_Spanish_CI_AS NOT NULL,
[TX_AUTO_ESCI_PERS] [nvarchar](18) COLLATE Modern_Spanish_CI_AS NOT NULL,
[FE_NACE_PERS] [datetime] NULL,
[NU_EDAD_PERS] [numeric](18, 0) NULL,
[TX_DOCU_PERS] [nvarchar](255) COLLATE Modern_Spanish_CI_AS NOT NULL,
[TX_NOM1_PERS] [nvarchar](255) COLLATE Modern_Spanish_CI_AS NULL,
[TX_NOM2_PERS] [nvarchar](255) COLLATE Modern_Spanish_CI_AS NULL,
[TX_APE1_PERS] [nvarchar](255) COLLATE Modern_Spanish_CI_AS NULL,
[TX_APE2_PERS] [nvarchar](255) COLLATE Modern_Spanish_CI_AS NULL,
[TX_AUTO_TIPE_PERS] [nvarchar](18) COLLATE Modern_Spanish_CI_AS NULL,
[TX_EMAIL_PERS] [nvarchar](255) COLLATE Modern_Spanish_CI_AS NULL,
[TX_AUTO_SEXO_PERS] [nvarchar](18) COLLATE Modern_Spanish_CI_AS NULL,
[NU_ELIM_PERS] [numeric](18, 0) NULL,
[NU_PSPE_PERS] [numeric](18, 0) NULL,
[TX_NUPS_PERS] [nvarchar](100) COLLATE Modern_Spanish_CI_AS NULL,
[FE_PSPI_PERS] [datetime] NULL,
[FE_PSPF_PERS] [datetime] NULL,
[NU_VISA_PERS] [numeric](18, 0) NULL,
[TX_AUTO_PAIS_VISA_PERS] [nvarchar](18) COLLATE Modern_Spanish_CI_AS NULL,
[NU_CARG_PERS] [numeric](18, 0) NULL,
[TX_DIRE_PERS] [nvarchar](255) COLLATE Modern_Spanish_CI_AS NULL,
[TX_TELE_PERS] [nvarchar](255) COLLATE Modern_Spanish_CI_AS NULL,
[NU_ACTI_PERS] [numeric](18, 0) NULL,
[TX_AUTO_ESCO_PERS] [nvarchar](18) COLLATE Modern_Spanish_CI_AS NULL,
[TX_AUTO_ETNI_PERS] [nvarchar](18) COLLATE Modern_Spanish_CI_AS NULL,
[TX_AUTO_ESSO_PERS] [nvarchar](18) COLLATE Modern_Spanish_CI_AS NULL,
[TX_AUTO_OCUP_PERS] [nvarchar](18) COLLATE Modern_Spanish_CI_AS NULL,
[NU_CABE_PERS] [numeric](18, 0) NULL,
[NU_LGBT_PERS] [numeric](18, 0) NULL,
[TX_CIUD_NACIMIENTO] [nvarchar](18) COLLATE Modern_Spanish_CI_AS NULL,
CONSTRAINT [PK_PERSONA] PRIMARY KEY NONCLUSTERED
(
[TX_AUTO_PERS] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY],
CONSTRAINT [UNIQ_DOCU_PER] UNIQUE NONCLUSTERED
(
[TX_DOCU_PERS] ASC
)WITH (IGNORE_DUP_KEY = ON) ON [PRIMARY]
) ON [PRIMARY]

NECESITO LA SOLUCION URGENTE