Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 View All Answers
How we can compare two database data?
What is the use of stored procedure?
what are cursors? : Sql server database administration
Mention what are the different types of ssrs reports?
Explain transaction isolation levels in sql server?
What is dbcc updateusage?
How to install sql server 2005 express edition?
How to implement service broker?
What is the difference between join and inner join?
Can a trigger be created on a view?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Mention the differences between local and global temporary tables.
How to drop existing views from a database in ms sql server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is default constraint?
