函数返回表

CREATE FUNCTION fnTest0331 ()

    RETURNS TABLE

AS

RETURN

    (

        SELECT   userid ,username

        FROM    usermaster

    )

 

 

declare

@u_id char(6), @u_name varchar(30)

begin

select @u_id= userid, @u_name=username

from fnTest0331 ()

select @u_id, @u_name

end