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
What is pivot and unpivot?
How many types of objects are there?
Mention the command used to rename the database.
How many triggers you can have on a table?
How many types of stored procedures are there in sql server?
how can a database be repaired? : Sql server administration
What are the dmvs?
What is pessimistic concurrency?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is user-defined functions? What are the types of user-defined functions that can be created?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What are the different types of triggers in SQL SERVER?
Distinguish between commit and rollback?
What is nolock?
what are different types of raid configurations? : Sql server database administration
