gpt4 book ai didi

timestamp - rowversion 不是 SQL Server 2008 R2 中的有效数据类型吗?

转载 作者:行者123 更新时间:2023-12-04 07:27:09 25 4
gpt4 key购买 nike

rowversion不是 Microsoft SQL Server 2008 R2 中的有效数据类型?

奖金喋喋不休

我正在尝试添加 rowversion列到表:

enter image description here

但是当我尝试离开“数据类型”列时,SQL Server Management Studio 会提示

Invalid data type.



enter image description here

并坚持我选择不同的数据类型:

enter image description here

我如何制作专栏 rowversionrowversion不是有效的数据类型?

奖金观看

enter image description here

奖励阅读

rowversion (Transact-SQL)

timestamp is the synonym for the rowversion data type and is subject to the behavior of data type synonyms. In DDL statements, use rowversion instead of timestamp wherever possible. For more information, see Data Type Synonyms (Transact-SQL).

The timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.



额外奖励聊天

最佳答案

SQL Server 2008 R2 接受 ROWVERSION 作为 CREATE TABLE 语句中列的数据类型,但是 SSMS 似乎滞后并且设计者拒绝接受输入。

关于timestamp - rowversion 不是 SQL Server 2008 R2 中的有效数据类型吗?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/8978097/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com