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 samples and sample databases are provided by microsoft?

0 Answers  

what kind of lan types do you know? : Sql server database administration

0 Answers  

What is catalog views?

0 Answers  

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

What are difference between Cluster index and Non-Cluster index?

0 Answers   QuestPond,

How to create a store procedure with encryption?

0 Answers  

How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  

What action plan is preferred if sql server is not responding?

0 Answers  

Why truncate is ddl?

0 Answers  

What are scheduled tasks in sql server?

0 Answers  

How to populate a table in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories