Interested to Buy Any Domain ? << Click Here >> for more details...
Different Types of Functions ?
- 2 Answers
- 12753 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / m.s.patil
Thre are mainly three types of functions in SQl server 2005.
1.) Scalar function
2.) Inline table valued function
3.) Multi statement table valued function
| Is This Answer Correct ? | 29 Yes | 5 No |
Answer / 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 |
What are examples of triggers?
Can two tables share the same primary key?
What are the differences between ms sql server & oracle?
What is for xml in sql server?
how can you attach more than 20 ldf files in sql server
Write a SQL query to delete a table?
What do you understand by coalesce in sql server?
when would you go for denormalization? : Sql server database administration
Can you tell me some of the common replication dmv's and their use? : sql server replication
What are the different sql server versions?
What is Service Broker in sql server 2012?
what changed between the previous version of sql server and the current version? : Sql server database administration
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
