In MySQL, I could hide these statements to insert 5 rows in one snapshot:
CREATE TABLE t (id int primary key auto_increment)
INSERT INTO t VALUES (DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT),(DEFAULT)
How can I do the same in MS SQL Server?
PS The reason the proposed duplicate does not solve the problem is because it contains tables with non-identical columns. My table contains only a column of identifiers.
source
share