Different Types of Functions ?
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 the different components in replication and what is their use?
What command do we use to rename a db, a table and a column?
What is a table called, if it does not have neither Cluster nor Non-cluster Index?
What is the diff between Dynamic queries and static queries
1 Answers CGG, ICS Integrated Computer Solutions,
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?
What is the difference between writing data to mirrored drives versus raid5 drives
How can I know what locks are running on which resource?
How to execute multiple stored procedures at one time in sql server?
What is cursors? And what are the different types of cursor?
What are different types of views?
Is index a datbase objects in sql server?
How to create a view with data from multiple tables?
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)