sql server - SQL Looping temp table and reading data -

i have following script create temp data

declare @name nvarchar(100), @marks int declare @mytable table (    [name][nvarchar](100) null,    [marks][int] null )  insert @mytable ([name],[marks]) values ('mark',50); insert @mytable ([name],[marks]) values ('steve',50); insert @mytable ([name],[marks]) values ('don',50); 

now want loop it, shown in below script

select @maxpk = max(pk) @mytable while @pk <= @maxpk begin  set @name =  select name @mytable   set @marks =  select marks @mytable     print @name  print @marks  set @pk = @pk + 1 end 

but error near select statement.

"incorrect syntax near keyword select"!

the 2 rows set variables can put this. way scan table once.

select @name = name, @marks = marks @mytable 

just know row chosen put in variables arbitary (and same row every time) unless add whereclause.