时间戳

首页 > 解决方案 > 我使用 Cosmos DB 并运行 SQL 命令并得到错误代码：SC1001

azure-cosmosdb - 我使用 Cosmos DB 并运行 SQL 命令并得到错误代码：SC1001

问题描述

下面是出现错误的行

--

CREATE TABLE `data_calculation` (
  `calcu_id` int(11) NOT NULL,
  `calcu_date` date NOT NULL,
  `totalalumni` int(11) NOT NULL,
  `totalmale` int(11) NOT NULL,
  `totalfemale` int(11) NOT NULL,
  `totaldkt` int(11) NOT NULL,
  `totaldkd` int(11) NOT NULL,
  `totaldkg` int(11) NOT NULL,
  `totaldkl` int(11) NOT NULL,
  `totaldkb` int(11) NOT NULL,
  `totaldcn` int(11) NOT NULL,
  `totalemployed` int(11) NOT NULL,
  `totalentrepreneur` int(11) NOT NULL,
  `totalunemployed` int(11) NOT NULL,
  `totalfurtherstudy` int(11) NOT NULL,
  `totalwaitingjob` int(11) NOT NULL,
  `totaldktsalary4001` int(11) NOT NULL,
  `totaldktsalary3001` int(11) NOT NULL,
  `totaldktsalary2001` int(11) NOT NULL,
  `totaldktsalary1501` int(11) NOT NULL,
  `totaldktsalary1001` int(11) NOT NULL,
  `totaldktsalary1000` int(11) NOT NULL,
  `totaldkdsalary4001` int(11) NOT NULL,
  `totaldkdsalary3001` int(11) NOT NULL,
  `totaldkdsalary2001` int(11) NOT NULL,
  `totaldkdsalary1501` int(11) NOT NULL,
  `totaldkdsalary1001` int(11) NOT NULL,
  `totaldkdsalary1000` int(11) NOT NULL,
  `totaldkgsalary4001` int(11) NOT NULL,
  `totaldkgsalary3001` int(11) NOT NULL,
  `totaldkgsalary2001` int(11) NOT NULL,
  `totaldkgsalary1501` int(11) NOT NULL,
  `totaldkgsalary1001` int(11) NOT NULL,
  `totaldkgsalary1000` int(11) NOT NULL,
  `totaldklsalary4001` int(11) NOT NULL,
  `totaldklsalary3001` int(11) NOT NULL,
  `totaldklsalary2001` int(11) NOT NULL,
  `totaldklsalary1501` int(11) NOT NULL,
  `totaldklsalary1001` int(11) NOT NULL,
  `totaldklsalary1000` int(11) NOT NULL,
  `totaldkbsalary4001` int(11) NOT NULL,
  `totaldkbsalary3001` int(11) NOT NULL,
  `totaldkbsalary2001` int(11) NOT NULL,
  `totaldkbsalary1501` int(11) NOT NULL,
  `totaldkbsalary1001` int(11) NOT NULL,
  `totaldkbsalary1000` int(11) NOT NULL,
  `totaldcnsalary4001` int(11) NOT NULL,
  `totaldcnsalary3001` int(11) NOT NULL,
  `totaldcnsalary2001` int(11) NOT NULL,
  `totaldcnsalary1501` int(11) NOT NULL,
  `totaldcnsalary1001` int(11) NOT NULL,
  `totaldcnsalary1000` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

网关检索查询计划失败：消息：{"errors":[{"severity":"Error","location":{"start":208,"end":211},"code":"SC1001", “消息”：“语法错误，'SET' 附近的语法不正确。”}]} ActivityId：d5f90a15-9fcc-44a5-8cdf-2fd34b811add，Microsoft.Azure.Documents.Common/2.14.0，Microsoft.Azure.Documents.Common /2.14.0

标签： azure-cosmosdb

解决方案

您收到此错误的原因是您尝试对 Cosmos DB 帐户执行 T-SQL 命令。

不能对 Cosmos DB 运行 T-SQL 命令。Cosmos DB SQL API 支持编写 SQL 命令，但它不同于为 SQL Server 编写的 SQL 命令。

请参阅此链接以了解针对 SQL API 的 Cosmos DB 帐户中的 SQL 命令支持：https ://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-getting-started 。

推荐阅读