CREATE FUNCTION dbo.Greatest--建立一个取得两个数最大值的函数 ( @val1 SQL_VARIANT, @val2 SQL_VARIANT ) RETURNS SQL_VARIANT AS BEGIN RETURN ( CASE WHEN @val1 > @val2 THEN @val1 ELSE @val2 END ) END --执行 select dbo.Greatest(2,8)
如果自定义函数是表值函数的话,在定义的视图里你就可以把自定义函数当成表一样来使用. 如:create view test_view as select * from dbo.your_function(par1,par2....)
( @val1 SQL_VARIANT,
@val2 SQL_VARIANT )
RETURNS SQL_VARIANT
AS
BEGIN
RETURN ( CASE WHEN @val1 > @val2 THEN @val1
ELSE @val2 END )
END
--执行
select dbo.Greatest(2,8)
如:create view test_view
as
select * from dbo.your_function(par1,par2....)