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 happens if strings are casted into wrong code pages in ms sql server?
What is set nocount on and what is set nocount off?
Difference between Sql server reporting services and Crystal reports?
is there a column to which a default can't be bound? : Sql server database administration
Explain what is “asynchronous” communication in sql server service broker?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Can an automatic recovery be initiated by a user?
List out the different types of locks available in sql server?
What is Transparent Data Encryption?
What are the purposes of floor and sign functions?
What are the characteristics of modern DBMS?
Which are new data types introduced in sql server 2008?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What is report server project?
Are connections to sql server encrypted?