USE Test
SET nocount ON


IF object_id('conc_test') IS NOT NULL
    DROP TABLE conc_test
GO
CREATE TABLE conc_test (id INT);
INSERT conc_test VALUES (1), (2), (3);

SET TRANSACTION isolation level serializable

DECLARE @id TABLE (id INT)

INSERT  @id
SELECT  top 10 id + 3
FROM    dbo.conc_test
ORDER BY
        id DESC

BEGIN TRANSACTION

INSERT  dbo.conc_test
        (id)
SELECT  t1.id
FROM    @id t1
LEFT JOIN
        dbo.conc_test ct
ON      ct.id = t1.id
WHERE   ct.id IS NULL

SELECT  *
FROM    sys.dm_tran_locks
WHERE   request_session_id = @@SPID

ROLLBACK TRANSACTION