DECLARE @Demo TABLE (MyDate DATETIME NOT NULL PRIMARY KEY CLUSTERED)
INSERT INTO @Demo (MyDate)
SELECT DATEADD(D, 1, GETDATE())
UNION ALL
SELECT DATEADD(D, -1, GETDATE())
UNION ALL
SELECT GETDATE()
SELECT MyDate FROM @Demo
SELECT MyDate, GetDate() FROM @Demo WHERE MyDate >= GetDate()
--Since all that code is executed at the same time, you should get 2 rows with the final select, if you get only 1 it's because the select was made 3+ ms after the insert
--wait 1 second
WAITFOR DELAY '00:00:01'
SELECT MyDate, GetDate() FROM @Demo WHERE MyDate >= GetDate()
--Now you should see only 1 row.