Anil from Chennai said..
1) Reflection in .Net Framework
Refelction is the mechanism of discovering class information solely at run time. Using Reflection, you can find the assembly details.
3)
1. Functions can be used in a select statement where as procedures cannot
2. Procedure takes both input and output parameters but Functions takes only input parameters
3. Functions cannot return values of type text, ntext, image & timestamps where as procedures can
4. Functions can be used as user defined datatypes in create table but procedures cannot
***Eg:-create table (name varchar(10),salary getsal(name)) Here getsal is a user defined function which returns a salary type, when table is created no storage is allotted for salary type, and getsal function is also not executed, But when we are fetching some values from this table, getsal function get’s executed and the return
Type is returned as the result set.