Why and when we use function in SQL?

Question

Dear frnds Why and when we use function in SQL? Please let me know in which scenario we use function?

Puneet Kankar · Answer

go through this link for deep https://docs.microsoft.com/en-us/sql/relational-databases/user-defined-functions/user-defined-functions

Puneet Kankar · Answer

we can't use single select in stored procedure because stored procedures execute for all but function we use like select name address dbo.functionname(gender) contact from table.

Puneet Kankar · Answer

Before SQL 2000 User Defined Functions (UDFs) were not available. Stored Procedures were often used in their place. One of the advantages of User Defined Functions over Stored Procedures is the fact that a UDF can be used in a Select Where or Case statement. They also can be used to create joins. In addition User Defined Functions are simpler to invoke than Stored Procedures from inside another SQL statement

Anjali Khan · Answer

Ok .and other thinks

Anjali Khan · Answer

Hi puneet Thanks for the update. But we can use select stmt from the stored procedure so why we used function.its my interview qus so what and can I gave to next interviewer?