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

could u plz explain about joins and views?

Question Posted / sarathraj

Answers were Sorted based on User's Feedback



could u plz explain about joins and views?..

Answer / vimal

VIEWS
View is a virtual table
If we want to access specific column from specific table we
can go for views
JOINS
Sometimes we have to select data from two or more tables to
make our result complete we have to perform join

Is This Answer Correct ?    3 Yes 0 No

could u plz explain about joins and views?..

Answer / mohsin mohammed abdul

basically we use joins to query a sql with 1 or more tables.
1) self join.. join within the same table using aliases
2) equi join.. join between the 2 tables with commom columns
3) outer join.. and it is divided into 2 catagories left
outer join and right outer join.

View :- its a logical representation of one or more tables.
View doesn't have the data of its own. But still you can
perform DML on a view ..the changes will be done in the
underlying base tables..

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the default value of CHAR type?

10 Answers   Bosch,

What is mean by candidate key?

0 Answers  

how to know description of a table in sqlserver 2000

8 Answers  

What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

what is difference between NULL and ISNULL in SQL Server 2008?

0 Answers   MCN Solutions,

Explain what are partitioned views and distributed partitioned views?

0 Answers  

in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers  

What is the New in SQL server 2008?

0 Answers  

Explain the etl (extraction, transformation, and loading)?

0 Answers  

Do you know how to make remote connection in database?

0 Answers  

What is the meaning of resultset type_scroll_insensitive?

0 Answers  

Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,

For more SQL Server Interview Questions Click Here
Categories