有没有办法迭代SQL Server中的表中的每一列

I have a table with 10 columns.What i need is to select each column through while loop(select each column name not each column values) and find if its name ends with 'box' if it is yes then add that column value to a variable.I have a table with 10 columns.What i need is t