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
Last modified: October 14, 2020

Author

Comments

Write a Reply or Comment