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
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Can we call future method from queueable?
What are the different sql server versions?
What’s the distinction between dropping a info and taking a info offline?
What is inner join? Explain with an example?
What are the different types of stored procedures?
How to use subqueries in the from clause in ms sql server?
What are the extra roles available in msdb? : sql server security
What is the architecture of ms sql reporting service?
How to insert and update data into a table with "insert" and "update" statements?
What is global temp table?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Do you know what is rank function?
What command do we use to rename a database?
Can another user execute your local temporary stored procedures?