What kind of User-Defined Functions can be created? ,Java, C ,C++, ASP, ASP.net C# ,Struts ,Questions & Answer, Struts2, Ajax, Hibernate, Swing ,JSP , Servlet, J2EE ,Core Java ,Stping, VC++, HTML, DHTML, JAVASCRIPT, VB ,CSS, interview ,questions, and answers, for,experienced, and fresher
What kind of User-Defined Functions can be created?

We can a create User-Defined Functions in a many ways they are defined as :
> Scalar User-Defined Function :  A Scalar user-defined function is basically a return value like one of the scalar data types. It is not a type of supported data types like Text,next,image and timestamps. These are the type of user-defined functions and most developers are used to in other programming languages. We pass in 0 to many parameters and We get a return value.
> Inline Table-Value User-Defined Function : An Inline Table-Value user-defined function mainly returns the value like a table data type and It is an exceptional alternative to a view as the user-defined function, It can pass parameters into a T-SQL select command and Its is poivide the essence with a parametrized, non-updateable view of the underlying tables.
> Multi-statement Table-Value User-Defined Function : A Multi-Statement Table-Value user-defined function is bassically a returns a table and It is a type of view which we can say like an exceptional alternative view as the function can support multiple T‐SQL statements to build the final result where the view is limited to a single SELECT statement. And Its also the ability to pass parameters into a T-SQL select command or a group of them gives us the capability to in essence create a parameterized, non‐updateable view of the data in the underlying tables. Within the create function command you must define the table structure that is being returned. After creating this type of user‐defined function, It can be used in the FROM clause of a T‐SQL command unlike the behavior found when using a stored procedure which can also return record sets.

More interview questions and answers
What are the differences between Get and post methods in form submitting, give the case where we can use get and we can use post methods?
What is PHP?
Tell more about PHP file?
How PHP is more secure than JavaScript?
What do you understand about MySQL?
Why do we use PHP?
How to install PHP in our system?
What is the Syntax of PHP?
Tell me about basic statements that we used in PHP?
What are the PHP variables?
What are the Limitations of Variable Naming?
How to declare data types in PHP?
What is the use of strlen() and strpos() functions?
Tell me about PHP operator?
Why we use Semicolon after SQL Statements?
How we use if..else and elseif statement in PHP?
Define the Primary key?
What do you mean by Candidate key?
What is the Foriegn Key?
How to use Switch statement in PHP?
What are the use of Null?
What do you understand with array in PHP?
What are the properties of the Relational tables?
What do you understand about Numeric array, Associative array and Multidimensional array?
What is De-Normalization?
What is the mean of Nested Trigger?
What is a Linked Server?
What do you understand about looping in PHP?
What is Cursor?
What is Collation?
What is Difference between Function and Stored Procedure?
What is the Sub-Query?And what is the properties of Sub-Query?
How to use while,do..while,for and foreach loop in PHP?
Give the list how many type of Joine?
Define : What is the Cross Join?
give us a definition of Inner Join?
What do you mean by Outer Join? and define also how many types of Outer Join?
Defeine : Self Join?
What is User Defined Functions?
What kind of User-Defined Functions can be created?
What do you understand functions in PHP?How we create them?
What is Identity?
What is DataWarehousing?
What is the clustered index?
What do you mean by A non clustered index?
How to handle form in PHP?
What are the different index configurations a table can have?
What are different types of Collation Sensitivity?
What is OLTP?
What is form validation?What is Client Side and Server Side validation?
What do you mean by TRUNCATE?
What do you mean by DELETE command?
When is the use of UPDATE_STATISTICS command?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What are the properties of SUB-QUERY?
What is the difference between constants and variables in PHP?
What are the type of SUB-QUERy?
What is SQL Profiler?
What is Ant?
What is a build tool?
How many types of build tool you know?
What is different between Ant and Make?
What is History of Ant?
Which version of Java is required to run Ant?
What are the authentication modes in SQL Server? How can it be changed?
Why do you call it Ant?
What is SQL Server Agent?
When we used $_GET and $_POST variable?
How you can Prepare a project in ANT?
Why we use $_REQUEST variable?
From where we can download Ant latest version?
Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?
Why we use Date() function in PHP and How?
What is Log Shipping?
Why we used Server Side include function?
What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?
How we use include() and require() function in PHP?
What is the mean of Local temporary table?
How to use File Handling in PHP?
What do u mean by Global temporary table?
What types of modes we use in PHP for File Handling?
How we use fopen(),fclose(),feof(),fgets() and fgetc()in PHP?
How we can set the PATH environment variable of ant?
What you know about Cookie?
What operation we can perform with Cookie?Explain it?
How we Sessions in PHP?
What is the STUFF function and how does it differ from the REPLACE function?
How we handle errors in PHP ?
How we use Simple \"die()\" statements error handling method in PHP?
How we use Custom errors and error triggers error handling methods in PHP?
What is UNIQUE KEY constraint?
How we use Error logging method in PHP?
What is CHECK Constraint?
What is NOT NULL Constraint?
What is a Scheduled Jobs or What is a Scheduled Tasks?
What are the advantages of using Stored Procedures?
What do you understand about Exception Handling in PHP?
What is BCP? When does it used?