INSERT INTO TestIdentityGaps (id, Description) VALUES (5, ‘Five Point One’) GO SELECT * FROM TestIdentityGaps Now you can see that the new rows have been inserted using the specified primary keys.