Paul White (@sql_kiwi) 's Twitter Profile
Paul White

@sql_kiwi

I write about deep SQL Server engine internals on sql.kiwi and live in Aotearoa New Zealand 🥝

MSFT Data Platform MVP 2011-2022
DBA Stack Exchange Mod

ID: 136093718

linkhttps://sql.kiwi calendar_today23-04-2010 01:02:21

14,14K Tweet

5,5K Takipçi

154 Takip Edilen

Paul White (@sql_kiwi) 's Twitter Profile Photo
Paul White
@sql_kiwi

4 months ago

This is a really funny SQL Server bug dbfiddle.uk/iUmhLPln DECLARE @T table (i smallint NOT NULL PRIMARY KEY); INSERT @T (i) VALUES (256); SELECT TRY_CONVERT(tinyint, T.i) FROM @T AS T; SET STATISTICS XML ON; -- Oops! SELECT T.i FROM @T AS T WHERE TRY_CONVERT(tinyint,