I am trying to replicate some of my queries of an access database into MS management studio and I came across some issues. I have a query on my access db which returns a Budget Code ( ParentCD ) as well as a Budget Code Description (ParentCDDesc) from a table called BudgetCD which are both short text data type.
When I run the query on access it returns exactly what I want, the ParentCD as numerical format and the ParentCDDesc in text, however when retrieving the same information on management studio using the same table I exported from access it returns the Parent Code (ParentCD) as well as the Parent Code Description (ParentCDDesc) both in numerical format. The two columns are declared as nvarchar(255) on management studio.
Can someone provide some idea to how to make the ParentCDDesc shows as text instead of showing as numerical? Right now the two columns looks exactly the same in management studio. See below.
03 Data Center Services
05 Operation Expenses
06 Salaries and Compensations
09 System Support Services
SQL Management studio view