I have a column in sql server with data type nvarchar(50) and its values are both numbers and alphabets.
My queries are something similar to
select code from table1
where owner = 'abc'
When copy and paste the output in excel, the values that are in numbers like '000032' are just pasted as '32' in excel. Similarly, 00012 as '12' and '00001' as '1'.
I'm not sure if I have to make any change in sql server query or sql server data type to make understand the excel or if it is something related to excel issue.