自定义函数+游标



use yuyongTest
go

create function dbo.getTotByName(@_name nvarchar(50))
returns int
as
begin
   declare @tot int;
   set @tot=0;
   declare @name nvarchar(50);
   set @name='';
   declare stuName cursor
   for
   select Name from student;
   --打开游标
   Open stuName;

   fetch next from stuName Into @name; 
   While ( @@Fetch_Status=0)  
      begin
         if(@name=@_name)
            set @tot=@tot+1;
         fetch Next From stuName Into @name;
      end
   --关闭游标  
   close stuName;
   --释放游标
   deallocate stuName;
   return @tot;
end
go

declare @t int;
select @t=dbo.getTotByName('qwe');
select @t;