本文介绍了插入 id(自动生成,仅列)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如果我不想在表中插入一行,而该表只包含一个带有自动生成 ID 的列,那么我的 SQL 语句 (MS-SQL) 应该是什么样的?
How should my SQL-Statement (MS-SQL) look like if I wan't to insert a row into a table, which contains only one column with the autogenerated id?
以下两个查询不起作用:
Following two queries won't work:
INSERT INTO MyTable (MyTableId) VALUES (Null) -- or simply INSERT INTO MyTable感谢任何提示.sl3dg3
Thx for any tipps. sl3dg3
推荐答案INSERT INTO MyTable (MyTableId) VALUES (Null) 隐式地尝试在标识列中插入一个空值,这样就不会作为标识列可能永远不能为空,如果没有 SET 选项,您无论如何都无法插入任意值,而是可以使用:
INSERT INTO MyTable (MyTableId) VALUES (Null) implicitly tries to insert a null into the identity column, so that won't work as identity columns may never be nullable and without a SET option you cannot insert an arbitrary value anyway, instead you can use:
INSERT INTO MyTable DEFAULT VALUES更多推荐
插入 id(自动生成,仅列)
发布评论