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
What is the order in which the sql query is executed?
What is save transaction and save point?
How to rebuild the master database?
List out some of the requirements to set up a sql server failover cluster?
How does stuff differ from the replace function?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
Is foreign key a primary key?
What are the functions in sql server?
Different types of keys in SQL?
Define right outer join?
Is it true, that there is no difference between a rule and a check constraint?
What are partitioned views?
How do we synchronize On-Premise SQL server with SQL Azure?
What is inner join? Explain with an example?
How exceptions can be handled in sql server programming?
