create function selectone(@name varchar(20))
returns table
as
return select userName,[passWord] from UserInfo where realName=@name
go
select * from selectone('袁敏敏') --函数调用方法
go
if exists(select 1 from sys.objects where name ='number')
drop function number
go
create function number(@bookName varchar(20))
returns varchar(20)
as
begin
return (select case
when bycount>=50 then '★★★★★'
when bycount>=40 then '★★★★'
when bycount>=30 then '★★★'
when bycount>=20 then '★★'
when bycount>=10 then '★'
end from BookInfo where bookname =@bookname)
end
select dbo.number('C语言程序设计')