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 DCL?
Explain about temporary stored procedure?
Explain what are the different index configurations a table can have?
How do I save a stored procedure in sql server?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What are the tool windows in sql server management studio? : sql server management studio
what is a self join? : Sql server database administration
How does recursive cte works in sql server?
What is molap and its advantage? : sql server analysis services, ssas
What is replace and stuff function in sql server?
What is cached report?
What is a fan-out query in SQL Azure?
What are the different ways you can create databases in sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Do you know what is a trace frag? Where do we use it?
