Different Types of Functions ?
Answers were Sorted based on User's Feedback
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 |
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 |
What is difference between joins and subqueries?
How reterive duplicate value in SQL?
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005
Difference between Triggers and Stored Procedure
23 Answers Claimat, HCL, Protech, Silgate,
Why is sql server log file full?
What is data modification?
Do you know the policy based administration feature of sql server 2008?
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 ?
What are the results of running this script?
What is the function of inner join?
Explain primary key?
Why Master database is required?