假设我有一个 int 字段,我将默认值设置为 (0),这可行,但我见过有人这样做((0)),为什么?
Let's say I have an int field, and I set the default value as (0), which works, but I've seen people doing it like this instead ((0)),why?
((0)) 是它在目录视图中或在 SSMS 中生成脚本时的显示方式.所以我认为当你看到它很可能是一个生成的脚本而不是从头开始手写的时候.
((0)) is how it will appear within the catalog views or if you generate a script in SSMS. So I think when you see that it's most likely a generated script and not hand-written that way from scratch.
也就是说,(0)、((0)) 甚至 ((((((((((((0))))))))))))) ...假设我数对了,额外的括号不会改变意思,只是可读性.
That said, there is nothing different between (0), ((0)) or even (((((((((((((0))))))))))))) ... assuming I counted right, extra parentheses don't change the meaning, just readability.
这篇关于带有两组括号而不是一组括号的默认值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持html5模板网!
将每个子标记转换为具有多个分隔符的单列-SQLConverting Every Child Tags in to a Single Column with multiple Delimiters -SQL Server (3)(将每个子标记转换为具有多个分隔符的单列-SQ
如何从多个表创建视图?How can I create a view from more than one table?(如何从多个表创建视图?)
根据前一行内的计算值创建计算值Create calculated value based on calculated value inside previous row(根据前一行内的计算值创建计算值)
如何将表格的前两列堆叠成一列,但也仅将第三How do I stack the first two columns of a table into a single column, but also pair third column with the first column only?(如何将表格的前两列堆
递归 t-sql 查询Recursive t-sql query(递归 t-sql 查询)
将月份名称转换为日期/月份编号(问题和答案的组Convert Month Name to Date / Month Number (Combinations of Questions amp; Answers)(将月份名称转换为日期/月份编号(问题和答案的组合