what are the ways to call user defined function in side Stored procedure?

Question

Hello, using select statement we can call functions inside the stored procedure, is there another ways to call functions inside the stored procedure.

Thank you,

Pradeep

Answer 1

try

SET @yourvariable = yourfunctionname('your params');

Answer 2

getdate() you can call inside a proc

-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:      <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE Proc1

AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    declare @date datetime

   set @date= getdate()
END
GO