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

What the different components in replication and what is their use?

0 Answers  

What command do we use to rename a db, a table and a column?

0 Answers  

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

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?

8 Answers  

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers  

How can I know what locks are running on which resource?

0 Answers  

How to execute multiple stored procedures at one time in sql server?

0 Answers  

What is cursors? And what are the different types of cursor?

0 Answers  

What are different types of views?

0 Answers  

Is index a datbase objects in sql server?

2 Answers  

How to create a view with data from multiple tables?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories