insert_data

INSERT INTO dbo.TEST
([ID],[COL1],[COL2],[COL3],[COL4],[COL5],[StartTime],[EndTime])
VALUES
(1,'a','b','c','d','e',GETDATE(),GETDATE()),
(2,'a2','b2','c2','d2','e2',GETDATE(),GETDATE()),
(3,'a3','b3','c3','d3','e3',GETDATE(),GETDATE()),
(4,'a4','b4','c4','d4','e4',GETDATE(),GETDATE()),
(5,'a5','b5','c5','d5','e5',GETDATE(),GETDATE()),
(6,'a6','b6','c6','d6','e6',GETDATE(),GETDATE()),
(7,'a7','b7','c7','d7','e7',GETDATE(),GETDATE()),
(8,'a8','b8','c8','d8','e8',GETDATE(),GETDATE()),
(9,'a9','b9','c9','d9','e9',GETDATE(),GETDATE()),
(10,'a10','b10','c10','d10','e10',GETDATE(),GETDATE())