Constraints Provide the Mechanism provide integrity in the data base to create a table to check some conditions.

There are Three type of constraints in sql server

1) Domain Integtity Constraint(not null,check)
2) Entity Integrity Constrinnt( Primary key ,Unique Key)
3) Referential Integrity Constraint(Parent table,Child Table Relationship)..


hope this will Hellp..
Let me know any Queries


Regards
Sriram.R

Joins Actualy performs Two or more table combined into a single result set..

Three are Four Types of joins in SQL SERVER.

1) inner join
2) Outer join(Left outer join,Right outer join)
3) Full join
4) Cross join

Regards
Sriram.R

allows you to add a new user to a database

row-by-row processing of the result sets

NULL is the default value of an integer data type?

Yes, COUNT(column) include columns with null values in its count?

TCL: TCL stands for Transactional Control Language. TCL is used to manage transactions within a database.
Examples: COMMIT, ROLLBACK statements

DDL -- Data Definition Language.
create and modify the structure of database objects.

Insert,
Update,
Delete,
Instead of

instance of data within relational database.