What is Identity?
Identity is a bassically called as AutoNumber. It is mainly a column that automatically generates numeric values. When A start and increment value can be set, but most DBA leave these at 1. A identity or GUID column also generates numbers; thease type of values cannot be controlled. Identity/GUID columns do not need to be indexed.
What kind of User-Defined Functions can be created?
We can a creat User-Defined Functions in a many ways they are defined as :
> Scalar User-Defined Function : A Scalar user-defined function is bassically a return value like one of the scalar data types. It is not a type of supported data types like Text,ntext,image and timestamp. These are the type of user-defined functions and most developers are used to in other programming languages. We pass in 0 to many parameters and We get a return value.
> Inline Table-Value User-Defined Function : An Inline Table-Value user-defined function mainly returns the value like a table data type and It is an exceptional alternative to a view as the user-defined function, It can pass parameters into a T-SQL select command and Its is poivide the essence with a parameterized, non-updateable view of the underlying tables.
> Multi-statement Table-Value User-Defined Function : A Multi-Statement Table-Value user-defined function is bassically a returns a table and It is a type of view which we can say like an exceptional alternative view as the function can support multiple T‐SQL statements to build the final result where the view is limited to a single SELECT statement. And Its also the ability to pass parameters into a T-SQL select command or a group of them gives us the capability to in essence create a parameterized, non‐updateable view of the data in the underlying tables. Within the create function command you must define the table structure that is being returned. After creating this type of user‐defined function, It can be used in the FROM clause of a T‐SQL command unlike the behavior found when using a stored procedure which can also return record sets.
What is User Defined Functions?
User Defined Functions is bassically signifies UDF, Its allow to define only its own T-SQL functions which is accept 0 or more parameters and return a single scalar data value or a table data type.Reply
Defeine : Self Join?
Self Join is bassically use for the editing in the table itself , This is a particular case when one table joins to itself, with one or two aliases to avoid confusion. A self join can joined tables which are the same. A self join is rather unique in that it involves a relationship with only one table. For the example is when company has a hierarchal reporting structure whereby one member of staff reports to another. Self Join also use can be Outer Join or Inner Join.Reply
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