SQL SERVER NOTES.............
Creates a user-defined function in SQL Server 2012. A user-defined function is a Transact-SQL or common language runtime (CLR) routine that accepts parameters, performs an action, such as a complex calculation, and returns the result of that action as a value. The return value can either be a scalar (single) value or a table. Use this statement to create a reusable routine that can be used in these ways: · In Transact-SQL statements such as SELECT · In applications calling the function · In the definition of another user-defined function · To parameterize a view or improve the functionality of an indexed view · To define a column in a table · To define a CHECK constraint on a colum...