自定义函数+游标

自定义函数+游标


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;