Ver Mensaje Individual
  #8 (permalink)  
Antiguo 20/10/2009, 10:32
tero_shevchenko
 
Fecha de Ingreso: noviembre-2008
Mensajes: 62
Antigüedad: 16 años
Puntos: 0
Respuesta: Migrar de Postgres a SQl Server

MIRA:

CREATE TABLE home (
street character(60) NOT NULL,
number integer NOT NULL,
apartment character(20),
floor integer,
notes character varying(255),
"inHand" varchar(10) NOT NULL,
"visitQ" integer NOT NULL,
contact character(80) DEFAULT '' NOT NULL,
habitants smallint DEFAULT 0 NOT NULL,
phone character(20) DEFAULT '' NOT NULL,
email character(100) DEFAULT ''NOT NULL,
"user" integer,
id integer NOT NULL,
ratio integer NOT NULL,
assigned_poller integer,
status character varying(15) DEFAULT 'NOT_ASSGINED' NOT NULL,
creation_date varchar(50) NOT NULL,
exist varchar(10) NOT NULL,
lat numeric DEFAULT 0.000000 NOT NULL,
lon numeric DEFAULT 0.000000 NOT NULL,
code numeric DEFAULT 1 NOT NULL
);

Inhand y Exist , eran booleans en postgres, les puse varchar y cuando hago este insert

INSERT INTO home (street, number, apartment, floor, notes, "inHand", "visitQ", contact, habitants, phone, email, "user", id, ratio, assigned_poller, status, creation_date, exist, lat, lon, code) VALUES ('espora ', 348, 'a2 ', 2, '', false, 3, ' ', 0, ' ', ' ', 32, 976, 368, NULL, 'FINISHED', '2009-09-09', true, -34.644901, -58.567109, 1);

me tira error