如何在sql中编写循环语句以获取一个参数中的值

i am so new to t-sql in sql server. how to loop through select result. example here:i am so new to t-sql in sql server. how to loop