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 Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

How to sort query output in descending order in ms sql server?

0 Answers  

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

How many types of Joins in SQL Server 2005?

9 Answers   CarrizalSoft Technologies, HCL,

syntax for deleting the database in T SQL

5 Answers  

What is ddl command?

0 Answers  

What is inline variable assignment?

0 Answers  

Explain stored procedure?

0 Answers  

What is Trace flag?

1 Answers   Wipro,

Explain couple pf features of SQL server

2 Answers  

Do you think BCNF is better than 2NF & 3NF? Why?

0 Answers   Ernst Young,

What is default constraint in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories