clare @x int,@sum int
set @x=0
set @sum=0
bz:
set @x=@x+1
set @sum=@sum+@x
while @x<100 goto bz
print '利用Goto语名求从1加到100的和：'+ cast(@sum as varchar(50))
--跳转语句 return
--创建自定义函数 计算奖金
create function myfun(@x int) returns int
as
begin
declare @y int
set @y=@x*0.15
return @y
END
select *,dbo.myfun(工资) as 奖金 from 职工