Generally, the data type of the column based on the column in the underlying table. If you need to change the data type of a column from a table or view, wec can replace the table with a named query that converts the column to the desired data type.
For example, we can use the following T-SQL code to convert Byte to Int data type:
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.