29/08/2009, 17:02
|
| | | Fecha de Ingreso: noviembre-2008
Mensajes: 28
Antigüedad: 15 años, 6 meses Puntos: 0 | |
| Ayuda Error en sintaxis
hola estoy usando el sql server 2005, me salen los siguientes errores creando la siguiente consulta
Código:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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) NULL COLLATE Latin1_General_CI_AS
) 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 NULL Latin1_General_CI_AS
) 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 NULL Latin1_Ge
Código:
Mens. 156, Nivel 15, Estado 1, Línea 7
Sintaxis incorrecta cerca de la palabra clave 'COLLATE'.
Mens. 156, Nivel 15, Estado 1, Línea 14
Sintaxis incorrecta cerca de la palabra clave 'NULL'.
Mens. 156, Nivel 15, Estado 1, Línea 25
Sintaxis incorrecta cerca de la palabra clave 'NULL'.
Plis si alguien me puede ayudar,gracias! |