--函数声明create function myAdd(@a int, @b int)returns intas begindeclare @c intset @c = @a + @breturn @cend --函数调用declare @a1 intdeclare @b1 int declare @c1 int set @a1 = 1 set @b1 = 100set @c1=dbo.myAdd(@a1,@b1)print cast(@c1 as nvarchar(10))