sql server 2008之自定义函数—标量值函数使用

1、创建标量函数-面积计算use hotelmanagementsysgocreate function area(@width int , @height int)returns intasbeginreturn @width * @heightend

2、标量函数引用-面积计算use hotelmanagementsysgoselect dbo.area(4 , 7) as '面积'

3、创建标量函数-房间入住信息的表use hotelmanagementsysgocreate table 房间入住信息(gname varchar(50),gno varchar(50),rno varchar(50),rtype varchar(50))

4、创建标量函数-查询顾客入住信息USE hotelmanagementsysGOcreate function getroomtypebyname(@name char(50))returns varchar(10)asbegindeclare @gno varchar(50) , @rno varchar(50) , @result varchar(50) = '暂无人居住信息'set @gno = select gno from 房间入住信息 where gname = @nameset @rno = select rno from 房间入住信息 where gno = @gnoset @result = select rtype from 房间入住信息 where rno = @rnoreturn @resultend

5、标量函数引用-查询顾客入住信息use hotelmanagementsysgoselect dbo.getroomtypebyname('琳琳') as '琳琳入住房间信息'