【SQL Sever】 函数的创建

--函数的创建create function getname (@stunumber char(6))returns varchar(20)with encryptionbegindeclare @stuname varchar(20)select @stuname=stuname from student where stunumber=@stunumberreturn @stunameend select * from studentcreate function getstudent(@claid int)returns tablewith encryptionreturnselect * from student where claid=@claidselect dbo.getname('200401') as '学生姓名'select * from getstudent(6)drop function getstudentCREATE TABLE bank(    customerName CHAR(10),  --顾客姓名    currentMoney MONEY     --当前余额)ALTER TABLE bank   ADD CONSTRAINT CK_currentMoney           CHECK(currentMoney>=1)INSERT INTO bank(customerName,currentMoney)        VALUES('张三',1000)INSERT INTO bank(customerName,currentMoney)        VALUES('李四',1)select * from bankdeclare @err1 int,@err2 intbegin transaction update bank set currentMoney=currentMoney-1set @err1=@err1+@@ERRORsave transaction transferUPDATE bank SET currentMoney=currentMoney-1000 WHERE customerName='张三'set @err2=@err2+@@ERRORUPDATE bank SET currentMoney=currentMoney+1000 WHERE customerName='李四'set @err2=@err3+@@ERRORif @err1 <> 0  beginrollback transactionprint '操作失败。。'  endelse  beginif @err2 <> 0  beginrollback transaction transferprint '转账失败。。'  end   end