SQL User Defined Functions

a. Scalar UDF: It returns a scalar value with datatype such as int, nvarchar, char, datetime and money
b. Table Valued UDF i. Inline Table value returning UDF -It defined with a single SELECT statement making up the body of the function. Inline table value-returning UDFs cannot contain additional T-SQL logic outside of the SQL SELECT statement that defines the table it will return. ii. Multistatement Table value returning UDF - This UDF is used if any additional logic needs to be included in the UDF in addition to select Statment. It allows to define multiple statement inside the UDF

Side by Side Execution

Side by side execution is the ability to Run multiple version of application and multiple version of CLR runtime in a same system at same time.

What is Assembly

Assembly is the Building Block of DotNet framework(it is a component). It forms the fundamental unit of deployment. It may be or may not be executables. It contains the definition of types , versioning information, meta-data , manifest

Types
Private - It should be in the local folder of calling application/ Dll Shared - It will be placed in the GACSatellite - It contains only resources, language specfic resources