can we call function from store procedure in Sql?

Hi.

You can't write functions inside the stored procedure but you can call functions inside the stored procedure. To know more you can follow this article,

 

https://www.c-sharpcorner.com/UploadFile/rohatash/calling-a-function-from-a-stored-procedure-in-sql-server-201/

 

If it helps Mark as answer.

Thanks.