What is a join and their types?
Answer Posted / hari
Joins are reterving the data from the multiple tables
Inner Join
Outer Join-left outer join
-----------right outer Join
-----------Full outer Join
Cross Join
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are drilldown reports?
What does it mean if @@cursor_row returns a negative number?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
How do you run a trace?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
How do you implement session management in SQL Server mode?
What is pessimistic concurrency?
What is table value parameters (tvp)?
What is a constant or literal in ms sql server?
What is the significance of master, tempdb and model databases?
What are the export options of ssrs?
Where are SQL server users names and passwords are stored in sql server?
What is stored procedures?
What are the types of table?
Do you know what is normalization of database? What are its benefits?