Create and call SQL server storage functions

1. scalar functions

　　1) Create

Create Function fun_max (@ x int, @ y int) -- scalar function returns int asbegin if @ x <@ Y set @ x = @ Y return @ xenddeclare @ x int, @ Y int set @ x = 1 Set @ Y = 2 print 'max = '+ Cast (DBO. fun_max (@ X, @ Y) as char)

Create Function fun_max (@ x int, @ y int) -- scalar function

Returns int

As

Begin

If @ x <@ Y

Set @ x = @ Y

Return @ x

End

　　2) Call
Declare @ x int, @ Y int

Set @ x = 1

Set @ Y = 2

Print 'max = '+ Cast (DBO. fun_max (@ X, @ Y) as char)

(Note: SQL statements cannot appear)

2. Table value functions

　　1) Create

 

Create Function fun_findid (@ id int)

Returns table

As

Return select * From renter where renterid> @ ID

　　2) Call

Select * From fun_findid (1001)

(Note: variables cannot be defined)