Custom Function + cursor

Custom Function + cursor

Please use yuyongTestgocreate function dbo. getTotByName (@ _ name nvarchar (50) returns intasbegindeclare @ tot int; set @ tot = 0; declare @ name nvarchar (50); set @ name = ''; declare stuName cursorforselect Name from student; -- Open the cursor Open stuName; fetch next from stuName Into @ name; While (@ Fetch_Status = 0) beginif (@ name = @ _ name) set @ tot = @ tot + 1; fetch Next From stuName Into @ name; end -- close the cursor close stuName; -- release the cursor deallocate stuName; return @ tot; endgodeclare @ t int; select @ t = dbo. getTotByName ('qw'); select @ t;