DELETE FROM [stbTable01]
GO
SET IDENTITY_INSERT [dbo].[stbTable01] ON
-- Image Review
INSERT [dbo].[stbTable01] (iColID, vcCol03, bCol02)
SELECT iColID, vcCol03, bCol02
FROM (VALUES
(1, 0, 'One'),
(2, 0, 'Two'),
(3, 0, 'Three'),
(4, 0, 'Four'),
(5, 0, 'Five'),
(6, 0, 'Six'),
(7, 0, 'Seven'),
(8, 0, 'Eight')
) R (iColID, bCol02, vcCol03)
SET IDENTITY_INSERT [dbo].[stbTable01] OFF
GO
Comments