function.sql

来自「简单的sql语句 数据与汇总。 高手多多指点。」· SQL 代码 · 共 56 行

use northwind
go

 create function fn_newregion
(@myinput nvarchar(30))
returns nvarchar(30)
begin 
  if @myinput is null
  set @myinput = 'Not Applicable'
  return @myinput
end
go

select * from employees
go

insert employees 
(lastname,firstname)
values 
('David','Hao')
go

select region from employees
go

select dbo.fn_newregion(region) as region from employees
go

--这里必须注明自定义函数的所有者，否则会显示错误

alter function fn_newregion
(@myinput nvarchar(30))
returns nvarchar(30)
begin 
  if @myinput is null
  set @myinput = '涛哥万岁'
  return @myinput
end
go

select * from shippers
go

alter function dbo.fu_shippers
(@companyname nvarchar(40))
returns table
as
return
(
 select * from shippers
 where companyname=@companyname
)
go


select * from dbo.fu_shippers('speedy express')