34,593
社区成员
发帖
与我相关
我的任务
分享
--可以不需要函数
declare @姓名 as varchar(10)
set @姓名 = 'XXX'
select count(*)
from 图书 a , 读者 b , 借阅 c
where b.c10 = @姓名 and b.编号C4 = c.读者编号C4 and c.书号C4 = a.书号C4
--如果要用函数
CREATE FUNCTION my_func(@姓名 varchar(10)) RETURNS int
AS
BEGIN
DECLARE @rtn int
select @rtn = count(*)
from 图书 a , 读者 b , 借阅 c
where b.c10 = @姓名 and b.编号C4 = c.读者编号C4 and c.书号C4 = a.书号C4
RETURN(@rtn)
END
go
SELECT dbo.my_func('xxx') AS '数量'