我使用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","Message":"语法错误,"SET"附近的语法不正确ActivityId:d5f90a15-9fcc-44a5-8cdf-2fd34b811add,Microsoft.Azure.Documents.Common/2.14.0,Microsoft.Azure.Documents/Common/2.14.0

出现此错误的原因是您试图对Cosmos DB帐户执行T-SQL命令。

不能对Cosmos数据库运行T-SQL命令。Cosmos DB SQL API支持编写SQL命令,但它与您为SQL Server编写的SQL命令不同。

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

相关内容

最新更新