I have inserted two records into a table.
create table num(id int) insert into num values(0023) insert into num values(23) select * from num
When I query them, they all display as
23. It means that SQL Server ignores the leading 0s. What's the mechanism behind that? How can I have SQL Server return the values as I inserted them (i.e.