tsql - 使用 T-SQL 创建表时，为什么最后一个字段后的尾随逗号不重要？

Question

这些语句中的一个不应该起作用而一个失败吗？

直觉说声明 2 应该失败，因为 后面有一个逗号国际并且没有列出第二列。

然而，工作和最后一列数据类型之后的尾随逗号“,”没有区别。

-- Statement 1
CREATE TABLE dbo.MyTable1( col1 int);

-- Statement 2
CREATE TABLE dbo.MyTable2( col1 int,);

但是(这是预期的):最后一个字段后的两个逗号“,,”确实会导致失败:

-- Statement 3
CREATE TABLE dbo.MyTable3( col1 int,,);

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ','.

测试表明它不仅仅是允许通过的最后一个字段之后的任何字符。例如，这失败了:

-- Statement 3
CREATE TABLE dbo.MyTable3( col1 int ~);

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '~'.

也许 SQL Server 正在“在 table 上留一个座位”？也许是主键？我真的不知道。

我使用的是 Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)。

Answer 1

见 http://connect.microsoft.com/SQLServer/feedback/details/273348/trailing-comma-allowed-in-create-table :

Description

When executing the CREATE TABLE command, a trailing comma following the last column is allowed. Based on the grammar in BOL and comma usage in lists in other T-SQL statements, this behavior is inconsistent. This is a very minor issue and does not appear to cause any adverse side-effects. It just appears that the parser may be a bit off.

微软认为这是一个错误，但只是一个小错误。

This was resolved some time ago as "won't fix" but we didn't explain why. Simply, this seems pretty harmless, and not worth fixing in a service pack. We may consider fixing this in a future release.