Answer Posted / 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 View All Answers
How to create a store procedure with encryption?
What is a group function explain with an example?
Explain the difference between functions and stored procedures in sql server?
How to make conditional sum in ssrs?
Can a database be shrunk with users active?
What is a non equi join?
What is named query? : sql server analysis services, ssas
What is db stored procedure?
Explain where clause?
Explain about SQLOS?
Describe different Processing Modes offered by SSRS?
What is merge replication?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What command is used to delete a table from the database in the sql server and how?
How to find the second highest salary of an employee?
