Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Different Types of Functions ?

Question Posted / sam

Answers were Sorted based on User's Feedback



Different Types of Functions ? ..

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

Different Types of Functions ? ..

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

Post New Answer

More SQL Server Interview Questions

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

0 Answers   IBM,

What are the different Topologies in which Replication can be configured?

0 Answers  

What are primary keys and foreign keys?

4 Answers  

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

What is the use of set nocount on/off statement?

0 Answers  

What are 3 ways to get a count of the number of records in a table?

0 Answers  

How do I find the sql server database version?

0 Answers  

What are the OS services that the SQL Server installation adds?

3 Answers  

What is delete query?

0 Answers  

how many triggers you can have on a table? : Sql server database administration

0 Answers  

Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories