如题所述
第1个回答 2017-03-03
用法上基本无差别，但VALUE并不是一个合法的T-SQL关键字
主要是定义上的区别：VALUES为Reserved Words，VALUE为Keywords
官方文档：
Reserved words and keywordsare identifiers that have special meaning in PL/SQL.
You cannot use reserved words as ordinary user-defined identifiers. You can use them as quoted user-defined identifiers, but it is not recommended. For more information, see"QuotedUser-Defined Identifiers".
You can use keywords as ordinary user-defined identifiers,but it is not recommended.
不能使用保留字作为用户定义的变量。但是当加上双引号就可以，但是不推存。
关键字就可以作为用户定义的变量，但是不推存。
主要是定义上的区别：VALUES为Reserved Words，VALUE为Keywords
官方文档：
Reserved words and keywordsare identifiers that have special meaning in PL/SQL.
You cannot use reserved words as ordinary user-defined identifiers. You can use them as quoted user-defined identifiers, but it is not recommended. For more information, see"QuotedUser-Defined Identifiers".
You can use keywords as ordinary user-defined identifiers,but it is not recommended.
不能使用保留字作为用户定义的变量。但是当加上双引号就可以，但是不推存。
关键字就可以作为用户定义的变量，但是不推存。
