select * from countries
where visit >= '20110101'
  and visit <= '20111231'

BEGIN TRANSACTION T1

DELETE
FROM dbo.countries WITH (TABLOCKX)
WHERE visit >= '20110101'
  AND visit <= '20111231'

--COMMIT TRANSACTION T1