maxxim010485
Member
Откуда:
Сообщений: 2
|
Есть такой запрос создания таблицы:
/****** Object: Table [dbo].[Conversations] Script Date: 02/08/2010 09:35:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dvr1].[dbo].[Conversations](
[Id] [int] IDENTITY(1,1) NOT NULL,
[ConversationId] [varchar](100) NOT NULL,
[AgentId] [nvarchar](50) NOT NULL,
[CustomerId] [nvarchar](50) NULL,
[StartTime] [datetime] NOT NULL,
[EndTime] [datetime] NULL,
[Important] [bit] NOT NULL,
[Teaching] [bit] NOT NULL CONSTRAINT [DF_Conversations_Teaching] DEFAULT (0),
[AvgAtmosphereAgent] [smallint] NULL,
[AvgEmoCogRatioAgent] [smallint] NULL,
[AvgEnergyAgent] [smallint] NULL,
[AvgUncertainlyAgent] [smallint] NULL,
[AvgIntensiveThinkingAgent] [smallint] NULL,
[AvgStressAgent] [smallint] NULL,
[AvgAngryAgent] [smallint] NULL,
[AvgUpsetAgent] [smallint] NULL,
[AvgAtmosphereCustomer] [smallint] NULL,
[AvgEmoCogRatioCustomer] [smallint] NULL,
[AvgEnergyCustomer] [smallint] NULL,
[AvgUncertainlyCustomer] [smallint] NULL,
[AvgIntensiveThinkingCustomer] [smallint] NULL,
[AvgStressCustomer] [smallint] NULL,
[AvgAngryCustomer] [smallint] NULL,
[AvgUpsetCustomer] [smallint] NULL,
[AvgEmoCogRatio] [smallint] NULL,
[AvgEnergy] [smallint] NULL,
[AvgUncertainly] [smallint] NULL,
[AvgIntensiveThinking] [smallint] NULL,
[AvgStress] [smallint] NULL,
[AvgAngry] [smallint] NULL,
[AvgUpset] [smallint] NULL,
[AvgAtmosphere] [smallint] NULL,
[OperatorGroup] [nvarchar](50) NULL,
[TenantId] [nvarchar](32) NULL,
[ExternalId] [nvarchar](30) NULL,
CONSTRAINT [PK_Conversations] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [IX_Conversations_ConversationId] UNIQUE NONCLUSTERED
(
[ConversationId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Ругается:
Msg 170, Level 15, State 1, Line 40
Line 40: Incorrect syntax near '('.
Что ему не нравится?!((( |
Помогите новичку))) [new]