use database function

 

1.return int type function

 

ALTER FUNCTION [dbo].[Foo]()
RETURNS int
AS
BEGIN
    declare @n int
    select @n=3
    return @n
END

------test------------
SELECT dbo.foo()

 

 

2.select user info by max id

 

 

CREATE FUNCTION getmax()
returns varchar(50)
AS
begin
    declare @name varchar(50)
    select @name = [name] from record where id=(select max(id) from record)
    return @name
end

 

-------test-------
SELECT * FROM record where name =(dbo.getmax())

SELECT dbo.getmax()