标量函数定义

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER FUNCTION [dbo].[GetCompanyNameById]
(
@Id int
)
RETURNS nvarchar(200)
AS
BEGIN
declare @name nvarchar(200)
select @name=subname from company where Id=@Id
return @name
END