create function abc(@a datetime,@b datetime)
returns datetime
as
begin
declare @c datetime
set @c = (case when @a >= @b then @a else @b end)
return @c
end
go--调用:
select dbo.abc('2003-01-01','2004-01-02')
或
select dbo.abc(字段1,字段2) from 表
returns datetime
as
begin
declare @c datetime
set @c = (case when @a >= @b then @a else @b end)
return @c
end
go--调用:
select dbo.abc('2003-01-01','2004-01-02')
或
select dbo.abc(字段1,字段2) from 表
select * from sales order by (case when ord_num>title_id then ord_num else title_id end)