SQL语句中的错误 [英] Error in sql statement

问题描述

ALTER TABLE AllotmentTab
ADD ID INT IDENTITY PRIMARY KEY,Registration AS '4MT08' + RIGHT('5100' + CAST(ID AS VARCHAR(50)), 6)
PERSISTED)

可以用任何一个telme来表示错误.它在PERSISTED

can any one telme what s the error.its showing error near PERSISTED

推荐答案

您正在数据定义查询中进行字符串连接-Registration AS ''4MT08'' + RIGHT(''5100'' + CAST(ID AS VARCHAR(50))，6)不能是

You are doing string concatenation in a data definition query - Registration AS ''4MT08'' + RIGHT(''5100'' + CAST(ID AS VARCHAR(50)), 6) cannot be included in this type of sql statement.

PERSISTED)似乎是一个独立的东西.它看起来像是属于某个东西的东西，而不属于上面的陈述.

祝您好运！

PERSISTED) looks to be something on its own. It looks like something that belongs to something and not to the statement above.

Good luck!

您正在尝试将数据处理和查询语法混合在一处. ALTER TABLE语句旨在修改表结构，这是第一部分正在做的事情.第二部分看起来像您正在尝试检索值.您要在这里实现什么?

You are attempting to mix Data Manipulation and Query syntax in one place. The ALTER TABLE statement is intended to modify a table structure, which is what the first part is doing. The second part looks like you are trying to retrieve a value. What are you trying to achieve here?

这篇关于SQL语句中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！