Please give me your valuable answers and thanks for responses.

Hello,

We can call user defined function from from the stored procedure.
like,

Select dbo.FunctionName(parameters of function) AS Function Return Value
From TableName

Function passing parameter should be in select statement.

Like,

Select A1, A2,A3, dbo.FunctionName(A1,A2) AS AValue From TableName

Thanks,
Viprat

yes
because,
store procedure consist of one or more sql queries
and In sql query we can call function so, alternately we can say that we can call function in store procedures

here is an example how to call function in sql query
e.g.

select getdate() --getdate() is sql-function

same way user-defined function can be called.
e.g

select dbo.fn_OnlyDate() --suppose, onlydate is user-defined sql function; (dbo is schema name because user defined function are accessed using schema name- just for your knowledge.)

Happy Coding!
:)

Hi,
The following statements are valid in a function:

Valid Operations in SQl-Functions:

Assignment statements.
Control-of-Flow statements except TRY...CATCH statements.
DECLARE statements defining local data variables and local cursors.
SELECT statements that contain select lists with expressions that assign values to local variables.
INSERT, UPDATE, and DELETE statements modifying local table variables.
EXECUTE statements calling extended stored procedures.

--Amit