陌生谁家年少

通过游标实现循环 -- 定义变量接收参数 declare @name nvarchar(50), @phone varchar(11) -- 声明游标 declare cc cursor for (select p.name, p.phone from T_User p) open cc fetch cc into @name, @phone while @@FETCH_STATUS = 0 begin -- do somthin..