How to create user define function using SQL Server

SQL Server Administration
,
1

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.

Thanks

1 Like
2

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

1 Like
3

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

4

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

http://www.sqlservercurry.com/2014/03/user-defined-functions-in-sql-server_20.html

https://www.mindstick.com/Articles/1101/create-a-user-define-function-using-sql-server-2008-r2

5

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

6

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.

1 Like