Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can you leave a union at any time?
Difference between aggregate functions of sql?
How each E-R model constructs can be mapped to the relational model?
Write query to return all rows sql?
What is key attribute?
Explain transaction server explicit transaction?
What is in place upgrade in sql server?
What is difference between aggregate and analytic function?
Explain the first normal form(1nf)?
Which are the new data types introduced in sql server 2008?
What is the significance of null value and why should we avoid permitting null values?
Explain atomicity?
What is self contained multi valued query?
What are the system database in sql server 2008?
Why use cursor in sql server?
