Can I write an insert-in statement for a single column table?

Question

Here's a warning ...

If you have a table in which there is one column, and this column is a column identitywith OFFidentity_insert disabled , can you still write the T-SQL insert statement for this table?

Answer 1

sure that

use insert TableName default values

Example

create table Test (id int identity not null)


insert Test default values

select * from Test