Ver Mensaje Individual
  #3 (permalink)  
Antiguo 31/08/2009, 19:52
Avatar de Andres95
Andres95
Colaborador
 
Fecha de Ingreso: diciembre-2004
Mensajes: 1.802
Antigüedad: 19 años, 5 meses
Puntos: 38
Respuesta: Ayuda Error en sintaxis

estaba mal escrito el ultimo renglon de cada tabla..

Código:
CREATE TABLE [dbo]. [GMInfo] (
[Id] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPart] [nvarchar] (50)  COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]

CREATE TABLE [dbo]. [GMLog] (
[LogIndex] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[SaveDate] [datetime] NULL,
[Description] [text] COLLATE Latin1_General_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo]. [GMLogView] (
[LogIndex] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPart] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[SaveDate] [datetime] NULL,
[Description] [text]  COLLATE Latin1_General_CI_AS NULL )
Saludos!
__________________
La sencillez y naturalidad son el supremo y último fin de la cultura...
--
MCTS : SQL Server 2008, .NET Framework 3.5, ASP.NET Applications.