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 |
How can we use ConnectorJ JDBC Driver with MS SQL?
What do you understand by the denormalisation?
What about UPDATESTATISTICS ?
which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM
Rate yourself in .NET and SQL ?
1 Answers Cognizant, HCL, SunGard,
How to count duplicated values in a column in ms sql server?
How does normalization work?
What is coalesce in sql server?
What will happen when a Rollback statement is executed inside a trigger?
1 Answers Flextronics, Hexaware,
What action plan is preferred if sql server is not responding?
Can you explain powershell included in sql server 2008?
What is filestream?
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)