What do you mean by Outer Join? and define also how many types of Outer Join?
Outer Join is the bassically use for a rows. That join includes rows even if related rows in the joined table are absent is an Outer Join. We can create three different outer join to specify the unmatched rows to be included :
> Left Outer Join : In Left Outer Join all rows in the first& named table i.e. "left" table, which appears leftmost in the JOIN clause are included. Unmatched rows in the right table do not appear.
> Right Outer Join: In Right Outer Join all rows in the second;named table i.e. "right" table, which appears rightmost in the JOIN clause are included. Unmatched rows in the left table are not included.
> Full Outer Join: In Full Outer Join all rows in all joined tables are included, whether they are matched or not.
give us a definition of Inner Join?
Inner Join is a bassically use for presention the tables or formate, A join that displays only the rows that have a match in both joined tables is known as inner Join. This is the default type of join in the Query and View Designer.
Define : What is the Cross Join?
A cross join is he type of join , That does not have a WHERE clause which is produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is bassically equal to the number of rows in the first table multiplied by the number of rows in the second table. For the example we can see when company wants to combine each product with a pricing table to analyze each product at each price.Reply
Give the list how many type of Joine?
There are diff types of join :
> Cross Join
> Inner Join
> Outer Join
* Left Outer Join
* Right Outer Join
* Full Outer Join
> Self Join
What is the Sub-Query?And what is the properties of Sub-Query?
Sub-queries are bassically defined as
sub-selects, Its allow a SELECT statement to be
executed arbitrarily within the body of another
SQL statement. A sub-query is mainly executed by
enclosing in a set of parenthesis. Sub-queries
are generally used to return a single row as an
atomic value, They may be used to comparision,
Its may be use for compare the values against
multiple rows with the IN-keyword. A Subquery is
a SELECT statement that is nested within another
T-SQL statement. A Subquery SELECT statement if
executed independently of the T-SQL statement, In
which it is nested, will return a resultset.
Meaning a subquery SELECT statement can stand
alone and is not depended on the statement in
which it is nested. A subquery SELECT statement
can return any number of values, and can be found
in, The column list of a SELECT statement,FROM,
GROUP BY,HAVING,and/or ORDER BY clauses of a
T-SQL statement. A Subquery can also be used as a
parameter to a function call. Basically a
subquery can be used anywhere an expression can
What is Collation?
Collation is bassically a collection to a set of
rules that determine how to data is sorted and
compared. Character data is sorted with using
rules that defined the sequence of correct
character, with specifying case sensitivity
options,and accent marks, and kana character
types and character width.Reply
What is Cursor?
Cursor is bassically a database object,which is manily used by applications to
manipulate data in a set on a Row by Row basis, Inastead of use the typical
SQL commands that operate on all the rows in the set at one time. In order to
workwith a cursor we need to perform some steps in theFollowing order :
> Declare cursor
> Open cursor
> Fetch row from the cursor
> Process fetched row
> Close cursor
> Deallocate cursor
What is a Linked Server?
Linked Servers is bassically a concept in SQL
Server, Its mainly use we can add the other SQL
Server to a Group and query both the SQL Server
dbs using T-SQL Statements. With a linked
server, We can also create very clean,easy to
follow, And SQL statements that allow remote data
to be retrieved, joined and combined with local
What is the mean of Nested Trigger?
A Trigger have a many authorities it can also perform to the INSERT,UPDATE and DELETE oprations or logic within itself, And whenever the trigger is fired the
reason is that data modification, It can also the reason is another data
modification, may be firing another trigger. A Trigger that contains data
modification logic within itself is called a nested trigger.
What are the properties of the Relational tables?
Relational tables have six properties which is there :
> In this table Values are atomic.
> In this table Column values are of the same kind.
> In this table Each row is unique.
> In this table The sequence of columns is insignificant.
> In this table The sequence of rows is insignificant.
> In this table Each column must have a unique name.Reply