how to write function in store procedure

like that you can select value by calling function from stored procedure

ALTER PROC [dbo].[USP_StoreProcedureName]
(
	@UserId int=0
)
AS
BEGIN
select dbo.Fun_FunctionName(@UserId)
end

--- function description 
ALTER Function  [dbo].[Fun_FunctionName]
(
	@UserId int=0
)
Returns  varchar(50)
AS
Begin
DECLARE @ReturnValue VARCHAR(20)
  --now set this variable as you like
  
 set @ReturnValue ---- your logic
return  @ReturnValue
end

Do you really mean a function or just how to select something in a stored procedure.

The simplest way is to just execute the query, like:

CREATE PROCEDURE abc
AS BEGIN
   SELECT ... FROM TheTable WHERE ...;
END;

Refer to CREATE PROCEDURE [^]

Hi,

You cannot define function in stored procedures.

Best Luck