SQLTeam.com | Weblogs | Forums

How to create user define function using SQL Server

sql2008
sql2008r2

#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


#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.


#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.