Different Types of Functions ?

Answers were Sorted based on User's Feedback



Different Types of Functions ? ..

Answer / m.s.patil

Thre are mainly three types of functions in SQl server 2005.
1.) Scalar function
2.) Inline table valued function
3.) Multi statement table valued function

Is This Answer Correct ?    29 Yes 5 No

Different Types of Functions ? ..

Answer / jijo

Three types

1) Scalar
A scalar user defined function returns one of the scalar
data type .text,ntext,etc

2) inline table Value
An inline table value function return a table data type

3) multi -statement table value function

A multi -statement table value function return a table and
is also an exceptional alternative to a view as the function
can support multiple t-sql statements to build the final result

Is This Answer Correct ?    26 Yes 4 No

Post New Answer

More SQL Server Interview Questions

What is difference between joins and subqueries?

0 Answers  


How reterive duplicate value in SQL?

6 Answers  


plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 Answers  


Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,


Why is sql server log file full?

0 Answers  






What is data modification?

0 Answers  


Do you know the policy based administration feature of sql server 2008?

0 Answers  


I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,


What are the results of running this script?

0 Answers  


What is the function of inner join?

0 Answers  


Explain primary key?

0 Answers  


Why Master database is required?

0 Answers   Abacus,


Categories