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 |
hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq
What are the different Topologies in which Replication can be configured?
What are primary keys and foreign keys?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is the use of set nocount on/off statement?
What are 3 ways to get a count of the number of records in a table?
How do I find the sql server database version?
What are the OS services that the SQL Server installation adds?
What is delete query?
how many triggers you can have on a table? : Sql server database administration
Will sql server 2005 allow you to reduce the size of a column?
Why I can not enter 0.001 second in date and time literals in ms sql server?
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)