SQLTeam.com | Weblogs | Forums

How to create user define function using SQL Server



Hi Guys

Please help to create user define funcation using sql server and tell me about different type of funcation 9in sql server.I would really appreciate your help.



That is a rather vague question. Look up the syntax for CREATE FUNCTION and let us know specifically which part you need help on.


I often use this statement. maybe she'll help you. https://msdn.microsoft.com/en-us/library/ms191007.aspx


Hi i refer some helpful link about user define funcation using sql server.I hope it will help you




Performance of Scalar User Defined Functions is terrible. Best to avoid them (which is possible using Table functions instead)


Specifically use an inline table-valued function and NOT a multi-statement table-valued function.

CROSS APPLY to the inline table-valued function in your query.