Can someone run the snippet below (in Q/A in grid mode) and explain what happens between rows 5136 & 5138 of the result set, if anything?

Best,

Juan Cristián

/******************/

create table #unicode([#] smallint, [unicode] char(1))

declare @i int

select @i = 0
while @i < 32000
begin
insert into #unicode
select
@i as [#]
,nchar(@i) as [unicode]

select @i = @i + 1
end

select * from #unicode

drop table #unicode

MS Sql Server LazyDBA home page